Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel - Averaging
I need to average multiple cells that are not continuous and ignore zero
values. The formula to ignore =AVERAGE(IF(A2:A7<0, A2:A7,"")) does not work for single cell entries (i.e. A2,A4, A6, A8) Is there a way to do this? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel - Averaging Over Multiple Workbooks | Excel Worksheet Functions | |||
Averaging Time withing Excel | Excel Worksheet Functions | |||
Averaging function is pulling back a zero in Excel | Excel Discussion (Misc queries) | |||
Averaging with excel | Excel Discussion (Misc queries) | |||
Adding/Averaging Times in Excel | Excel Discussion (Misc queries) |