| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2002 Min Function | Excel Discussion (Misc queries) | |||
| Error Handling #N/A with AVERAGE Function - Average of values in Row | Excel Worksheet Functions | |||
| average function in Excel 2002 | New Users to Excel | |||
| Excel/Access 2002 sum function | Excel Worksheet Functions | |||
| Where is DateDiff function in Excel 2002 ? | Excel Worksheet Functions | |||
Linear Mode
