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
 

Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)
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)
 
Upvote 0

Forum statistics

Threads
1,213,558
Messages
6,114,297
Members
448,564
Latest member
ED38

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top