Forum Discussion
Using Formula MONTH() in SUMIFS()
My simplified table looks like this - Date Category Amount 8/1/2023 Housing $100.00 8/1/2023 Groceries $200.00 9/1/2023 Groceries $100.00 9/1/2023 Utilites $200.00 I am...
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)))
Thank you