# Multiple "IF" Query - Is this possible?

#### Tori83

##### New Member
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

### Excel Facts

If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.

#### Misca

##### Well-known Member
Welcome to the board!

=SUMIFS(\$D\$2:\$D\$28,\$B\$2:\$B\$28,\$J\$1,\$C\$2:\$C\$28,I3)

#### Tori83

##### New Member
THANK YOU! Youre a legend

Replies
1
Views
72
Replies
18
Views
203
Replies
3
Views
95
Replies
3
Views
235
L
Replies
3
Views
89