Hi there, I cannot seem to wrap my brain around this one, its possibly basic but no amount of googling is saving my *** and its now 3:30am lol
I am creating a budget where I will enter all my spending in columns A-D, the categories are selected via drop down in column C. The drop down originating list is in column I which will then have a total sum of "Spend" "Budget" (which i will input manually) and then column L is the difference (so i can see where I have over/under spent)
Currently in column J is the formula ; =SUMIF(C:C,@I:I,D:D)
This is to bring back to me the total spend per category
What I want to do though is further break it down to specific months.
I was thinking of adding to the start an "IF" statement and making it ; =IF(B3=K2,SUMIF(C:C,@I:I,D:D))
But this is just bringing back a "FALSE" error.
As you can see from the picture below currently both OCT and NOV bring back the same values, I would want it to only bring back the total values per category for each specific month.
Any suggestions would be greatly appreciated!
-Tori
I am creating a budget where I will enter all my spending in columns A-D, the categories are selected via drop down in column C. The drop down originating list is in column I which will then have a total sum of "Spend" "Budget" (which i will input manually) and then column L is the difference (so i can see where I have over/under spent)
Currently in column J is the formula ; =SUMIF(C:C,@I:I,D:D)
This is to bring back to me the total spend per category
What I want to do though is further break it down to specific months.
I was thinking of adding to the start an "IF" statement and making it ; =IF(B3=K2,SUMIF(C:C,@I:I,D:D))
But this is just bringing back a "FALSE" error.
As you can see from the picture below currently both OCT and NOV bring back the same values, I would want it to only bring back the total values per category for each specific month.
Any suggestions would be greatly appreciated!
-Tori