Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to overlook zeros in a calculation?
I am calcing a median value for a range, and the range includes zeros. I've
tried an array formula: ={if(A1:A40,median(A1:A4),0)} and another version of the same: ={Median(if(A1:A40,A1:A4,0))} Both of these formulas include the 0 values in the median calculation. Does anyone know how I can remove them? Thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Essbase: Text zeros to number zeros | Excel Discussion (Misc queries) | |||
Median calculation and ignore zeros | Excel Discussion (Misc queries) | |||
Charting zeros as non zeros | Charts and Charting in Excel | |||
How to sum a row of cells containing an error message to overlook | Excel Worksheet Functions | |||
save text field w/ leading zeros in .csv format & not lose zeros? | Excel Discussion (Misc queries) |