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

Pivot Table Drill Down
Double-click any number in a pivot table to create a new report showing all detail rows that make up that number

Misca

Well-known Member
Joined
Aug 12, 2009
Messages
1,627
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,655
Messages
5,549,261
Members
410,905
Latest member
Extjel
Top