Excel Averageifs

Is it possible to use an OR condition in excel averageifs?  If so, can someone please demonstrate an example for me?

Thanks..
LVL 1
fb1990Asked:
Who is Participating?
 
Wayne Taylor (webtubbs)Connect With a Mentor Commented:
Not with AVERAGEIFS, but you can Array enter an AVERAGE function to provide an OR test...

=AVERAGE(IF((A1:A20="data2")+(A1:A20="data4"), B1:B20))
AVERAGEOR.xlsx
0
 
fb1990Author Commented:
Thank you very much.  Is there a non array formula that can be used?  Otherwise it worked for me.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.