I am trying to exclude the word
PPC from these results and am mixing a few items to get it. It returns the correct number for PPC contracts here, but I want it to exclude anything with PPC in cell
G3-G. I understand that
<> can be used for
does not equal but I've tried inserting that multiple places in this ISNUMBER/SEARCH formula and can't figure it out. Is there a better way to get the same answer with a different formula?
The piece I need help with:
The full formula:
=SUMPRODUCT((--(MONTH(Retention!$E$3:$E)=MONTH(S$1))*(YEAR(Retention!$E$3:$E)=YEAR(S$1))*(Retention!$D$3:$D="Sales - USA")*(ISNUMBER(SEARCH("PPC", Retention!$G$3:$G)))*(Retention!$H$3:$H="")))