Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need help (Average excluding zero values)
This is what i have & it works but one problem there will be zero values & i
need to exclude them if possible =AVERAGE(IF(AA5="L",E$5:E$65)) I have tried several different combinations I can,t get it |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need help (Average excluding zero values)
that includes zero values in the average for me. are they blanks and not zeroes?
-- Gary Keramidas Excel 2003 "Mike" wrote in message ... This is what i have & it works but one problem there will be zero values & i need to exclude them if possible =AVERAGE(IF(AA5="L",E$5:E$65)) I have tried several different combinations I can,t get it |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need help (Average excluding zero values)
Is you aim to compute the average only when AA5 ="L" ?
Then you formula should be =IF(AA5="L", AVERAGE(E$5:E$65), "") To omit zeros in the average =IF(AA5="L",AVERAGE(IF(E$5:E$65<0,E$5:E$65)),"") This is an array formula and Excel will enclose in in braces { ... } This is a non-array formula that does the same =IF(D1="L",SUM(A1:A7)/COUNTIF(A1:A7,"<0"),"") best wishes -- Bernard Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme "Mike" wrote in message ... This is what i have & it works but one problem there will be zero values & i need to exclude them if possible =AVERAGE(IF(AA5="L",E$5:E$65)) I have tried several different combinations I can,t get it |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
getting an average while excluding high and low input | Excel Worksheet Functions | |||
Average of values in row excluding the highest and lowest value? | Excel Worksheet Functions | |||
excluding valuse from an average | Excel Discussion (Misc queries) | |||
AVERAGE excluding #N/A | Excel Worksheet Functions | |||
EXcluding Zeros from the average in a row | Excel Discussion (Misc queries) |