I’m looking to tally up the occurrences of “Apple” or “Orange” that are categorized as either “Eaten” or “Half Eaten” for each month. This is for a Google Sheets project.
Currently, I have tried the following formulas but they aren’t producing the expected results:
=SUM(COUNTIFS(H:H,A2,J:J,{"Eaten","Half Eaten"},I:I,{"Apple";"Orange"}))
=SUMPRODUCT(ISNUMBER(MATCH(H:H,A2,0))*ISNUMBER(MATCH(I:I,{"Apple","Orange"},0))*ISNUMBER(MATCH(J:J,{"Eaten","Not Eaten"},0)))
Interestingly, the first formula appears to work fine in Excel but fails in Google Sheets.