On Mar 8, 11:50 pm, "Roger Govier"
wrote:
"joeu2004" wrote:
On Mar 8, 4:21 pm, "Roger Govier" wrote:
=AVERAGE(ESP1!F24+ESP2!F24+LV!F24+LA!F24+RAT!F24+S F1!F24+
SF2!F24+SF3!F24+TA*OS!F24)
then if they sum to 0, you will get the #DIV0 error message

Are you sure? Works fine for me when all cells are on the same sheet.

Sorry,

I should have said if all cells in the range are blank, and therefore
sum to zero, then you get the #DIV/0 error.

Not when I try it. AVERAGE(A1+A2+A3) works just fine when all 3 cells
are blank. I suspect you are making the same mistake that I made and
thinking of AVERAGE(A1,A2,A3), which does indeed fail with #DIV/0! if
all 3 cells are blank.