Multiple "IF" Query - Is this possible?

Tori83

New Member
Joined
Oct 25, 2020
Messages
2
Office Version
  1. 365
Platform
  1. Windows
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

Budget.jpg
 

Some videos you may like

Excel Facts

Links? Where??
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
Joined
Aug 12, 2009
Messages
1,626
Welcome to the board!

Use SUMIFS instead of SUMIF:
=SUMIFS($D$2:$D$28,$B$2:$B$28,$J$1,$C$2:$C$28,I3)
 

Watch MrExcel Video

Forum statistics

Threads
1,114,314
Messages
5,547,169
Members
410,775
Latest member
alal1030
Top