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