averages in a range of sheets

  • Thread starter Thread starter steve
  • Start date Start date
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
 
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
 
Back
Top