Excel 2002 AVERAGE Function
 

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.
--
ELB

Excel 2002 AVERAGE Function
 

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

"ELB" wrote in message
...
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.
--
ELB