Sum all values with same month and category

Question

So I have this table where I'm writing down my daily expenses. On one cell I choose the date, the next cell I choose the category and in the third, I insert the amount of money spent. On another sheet I have another table where I want to add the values that have the same months and categories in common:

One cell for "Food" in "January", another for "travel" in "January" then on another table "Food" in "February" and so on...

I tried something like:

=LOOKUP("Food",$E$16:$E$18,$D$16:$D$18 )

or:

=IF(MONTH(B16)=1, 
 IF(C16="Food",+D16))+
 IF(MONTH(B17)=1, 
 IF(C16="Food",+D17))

or even:

=IF(ISBLANK(D2);"";SUM(FILTER($B$2:B;$A$2:A=D2)))

and so on...

But none of this is working as I want.

Does anyone have any idea about how to go about doing this?

My file: https://docs.google.com/spreadsheets/d/13R6xUhZCX-wjOPXfpiZYOgsN18oLo8QTuYJ2H4mqqos/edit?usp=sharing

Answer 1

• paste this into C3 and drag down:

  =IFERROR(QUERY(Daily!$B:$D, 
   "select sum(D) 
    where C = '"&B4&"' and month(B) + 1 matches '"&MONTH(B$3&1)&"' 
    group by C
    label sum(D)''", 0), 0)

• then copy cell C3 and paste it in G3 and drag down...