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