I was able to get it to work. I used the code =SUMIFS(D2:D203, A2:A203, "Not Cooked", C2:C203, G2:G203)
. I'm not sure why switching the order of the criteria changed the output to one that worked, perhaps by starting with the criterion which applies to every row it allows for the second criterion to be one which has less rows, since there are less unique ingredients then there are ingredient entries next to the meals.