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.
=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.