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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Average function 9
AVERAGE cells on another worksheet when the range is calculated 1
Zero in Average problem 7
AVERAGEIF 4
If Statement not to include O when doing average 1
Average Formula Help 4
average with max 8
Get "AVERAGE" function to ignore empty cells 6

Back
Top