Array?

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

John C

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top