| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel - Averaging
try this
=AVERAGE(IF(A2:A7<0,A2:A7)) ( use ctrl + shift + enter ) On Dec 10, 2:12*am, Christy wrote: 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) | |||
Threaded Mode
