try this

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


On Oct 24, 7:56*pm, PAL wrote:
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),"")