SUMIFS using an OR operator

[miconian]

Basically, I'm using SUMIFS, and the final criterion could go one of two ways: either EMER or APPC are valid values.

Here's my formula:

=SUMIFS(Data2011[Net Amount],Data2011[Internet Site],A13,Data2011[Confidence %],"B",Data2011[Ad Unit],"EMER")

The last criterion, Data2011[Ad Unit],"EMER" is correct, but incomplete. Another valid criteria for [Ad Unit] should be "APPC".

So I'm trying to do something like this:

=SUMIFS(Data2011[Net Amount],Data2011[Internet Site],A13,Data2011[Confidence %],"B",Data2011[Ad Unit],"EMER" OR Data2011[Ad Unit],"APPC")

or perhaps:

SUMIFS(Data2011[Net Amount],Data2011[Internet Site],A13,Data2011[Confidence %],"B",OR((Data2011[Ad Unit],"EMER"),(Data2011[Ad Unit],"APPC"))

What am I missing?

 

[Aladin Akyurek]

Seems likes it's doing the trick.


I've now just changed a few formula's: 12 of the 372 I have to do, but I forgot to slide them on into the full 372. Funny thing is, it already worked like a charm I think. Given that I monitored my RAM and it *dropped* in comparison to the starting point. I don't what kind of magic that is, but I don't rule out a coincidence there.


I'm gonna slide them on, try further. (I'm way too enthousiastic about this by the way, I feel as if I'm 12yrs old.)


Ok, pulled the formula's through. It is working beautifully. Thanks.

And then a few hundred thankses on top of that.

Sounds great. Thanks for the update.