Excel 2002 AVERAGE Function

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to calculate the average of a range of cells that are in 12 sheets
within the same workbook. I also need to exclude all number 0's from the
calculations. Any suggestions would be greatly appreciated.
 
The formula to do this is long, ugly, complicated and not efficient.

You'd be better off using formulas on each sheet then linking to those cells
from a summary sheet(?).

Biff
 
Back
Top