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