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:
=IF(MONTH(B16)=1, IF(C16="Food",+D16))+ IF(MONTH(B17)=1, IF(C16="Food",+D17))
and so on...
But none of this is working as I want.
Does anyone have any idea about how to go about doing this?