My current formula is: =AVERAGE('Week 1'!G4,'Week 2'!G4,'Week 3'!G4,'Week 4'!G4,'Week 5'!G4). When there is no Data entered on any one of the Week1-5 sheets I'm obviously getting the #DIV/0! error.
I thought something like one of these would do it but I just cannot figure out what I'm missing here.
=AVERAGEIF('Week 1'!G4,'Week 2'!G4,'Week 3'!G4,'Week 4'!G4,'Week 5'!G4, ">0")
=IfError(AVERAGEIFS('Week 1'!G4,'Week 2'!G4,'Week 3'!G4,'Week 4'!G4,'Week 5'!G4,)