Averageifs + "or", possible to do somehow?

[Jennifre]

I need to average cells which are labeled in a different column. Combining the averageifs function I think does not work with "or" criteria, so I tried this [but it's not working].

Is there a way to do this?

My effort:
=AVERAGE(IF(OR(DG2:DG1364=1212)+(DG2:DG1364=1222)),DJ2:DJ1364)

So I need to average column DJ, only for the rows whose DG column values equal 1212 or 1222. I need to use "or" not "and".

Thank you...!

 

[Domenic]

Try the following formula, which needs to be confirmed with CONTROL+SHIFT+ENTER...

=AVERAGE(IF(ISNUMBER(MATCH(DG2:DG1364,{1212,1222},0)),DJ2:DJ1364))

 

[T. Valko]

I need to average cells which are labeled in a different column. Combining the averageifs function I think does not work with "or" criteria, so I tried this [but it's not working].

Is there a way to do this?

My effort:
=AVERAGE(IF(OR(DG2:DG1364=1212)+(DG2:DG1364=1222)),DJ2:DJ1364)

So I need to average column DJ, only for the rows whose DG column values equal 1212 or 1222. I need to use "or" not "and".

Thank you...!

You were pretty close. Just remove the OR:

Array entered**:

=AVERAGE(IF((DG2:DG1364=1212)+(DG2:DG1364=1222),DJ2:DJ1364))

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER). Hold down both the CTRL key and the SHIFT key then hit ENTER.

 

[Jennifre]

Awesome, thank you Biff !! I really appreciate your help, thank you.

 

[T. Valko]

Awesome, thank you Biff !! I really appreciate your help, thank you.

You're welcome. Thanks for the feedback!