Excel 2002 AVERAGE Function

E

ELB

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

T. Valko

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
 
Top