Array?

[PAL]

Iam working with the formula below I do add the brackets for an array.

I am looking at a range of rows, If Column E is "Medium" and Column E has a
value in it, then give me the average of E.

A blank is returned. Please advise.


=IF(AND($F$2:$F$34="Medium",$E$2:$E$34>""),AVERAGE($E$2:$E$34),"")

 

[muddan madhu]

try this

=AVERAGE(IF(F5:F16="medium",E5:E16,"")) ( use ctrl + shift + enter )

 

[John C]

Try this array formula:
=AVERAGE(IF($F$2:$F$34="Medium",IF($E$2:$E$34<>"",$E$2:$E$34,""),""))

 

[John C]

This will give you an error #DIV/0 if there are no values next to a Medium

 

[PAL]

This works. Thanks. If I change average to Count, it doesn't. Thoughts?

 

[John C]

COUNT works for me, what are you getting? What do you expect to get?

 

[PAL]

Got it, not sure what I did the first time. thanks.