Excel 2002 AVERAGE Function

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

 

[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