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

--
** John C **

"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),"")