=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="")))