| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Average non zero values
I recall reading this and now cant find it.
A column of data with numerical values, some empty cells and some with zero's. I need to calculate the average, but supress cells with zeros from the calculation. I tried =IF((A1:A44)<0,AVERAGE(A1:A44)) arrayed entered, but no go. Suggestions welcomed, and my thanks. Paul |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Average Values / Multiple Worksheets | Excel Worksheet Functions | |||
| Conditional math using AND, Average | Excel Worksheet Functions | |||
| Count Intervals of Filtered TEXT values in Column and Return Count across a Row | Excel Worksheet Functions | |||
| How to average a column, but exclude zero AND negative values? | Excel Discussion (Misc queries) | |||
| How do I average a formula without calculating zero values? | Excel Discussion (Misc queries) | |||
Threaded Mode
