I need multiple "*Programs*" qualifiers in one SUMIFS formula.

[RodneyC]

I need to modify this formula:

=SUMIFS(Data4Adcel!$O:$O,Data4Adcel!$M:$M,"*Programs*",Data4Adcel!$A:$A,"*AdCell*")

So that instead of only looking for "*Programs*" in M:M it is also looking for "*Standard*" or "*Premium*" also in M:M if it finds any of those three values Programs, Standard or Premium" it will Sum the value(s).

Thanks in advance.

 

[kweaver]

Try:

=sum(SUMIFS(Data4Adcel!$O:$O,Data4Adcel!$M:$M,{"*Programs*","*Standard*","*Premium*"},Data4Adcel!$A:$A,"*AdCell*"))

 

[RodneyC]

Try:

=sum(SUMIFS(Data4Adcel!$O:$O,Data4Adcel!$M:$M,{"*Programs*","*Standard*","*Premium*"},Data4Adcel!$A:$A,"*AdCell*"))

That worked perfectly. Thank you

 

[kweaver]

Glad to hear.