Re: Using Formula MONTH() in SUMIFS()

Jlkirk 

Using the example from higher up:

=SUMIFS(C2:C1000, B2:B1000, "*Groceries*")

and

=SUMPRODUCT(C2:C1000, (MONTH(A2:A1000)=8)*ISNUMBER(SEARCH("Groceries", B2:B1000)))