Home |
Search |
Today's Posts |
#17
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
help on averaging function
"Dave Thomas" wrote...
His data could be all negative numbers for all I know. He said he just wanted to eliminate 0's and blanks. .... In that case, =AVERAGE(IF(dataset<0,dataset)) or getting really pedantic, =CHOOSE(1+SIGN(COUNTIF(dataset,"<0"))+2*SIGN(COUNT IF(dataset,"0")), 0+N("no positivess or negatives, so live with 0"), AVERAGE(IF(dataset<0,dataset)),AVERAGE(IF(dataset 0,dataset)), AVERAGE(dataset)+N("both positives and negatives, so should include 0s")) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Looking for conditional averaging or "Averageifs" function for | Excel Worksheet Functions | |||
Looking for conditional averaging or "Averageifs" function for | Excel Worksheet Functions | |||
Looking for conditional averaging or "Averageifs" function for '02 | Excel Worksheet Functions | |||
Averaging function is pulling back a zero in Excel | Excel Discussion (Misc queries) | |||
Averaging function | Excel Discussion (Misc queries) |