averages in a range of sheets

S

steve

Hi Again
I have another problem for you.
I have a workbook with 52 sheets with a total of averages
on each sheet. Then I have a 4-month total and yearly
total. How do I get the averages on my annual sheets and
yearly sheet to come out if some of the sheets end up
blank in the total cell.
All my totals on the sheets are in the same cell.
H12. Hope this makes sense.
Thanks
Steve
 
T

Tom Ogilvy

Average supports 3D references and it ignores blank cells

=Average(Sheet1:Sheet12!B30)

If all the cells addressed are blank, it will return a #DIV/0 error.


Regards,
Tom Ogilvy
 
Top