Multiple If functions???

[CharismaticCity]

Hello all,

I have a database that displays the following data (date, ID, Category, Item, and Amount paid) for monthly payments.. for an example "

date ID Category Item Amount paid

June 5, 2018 WPS Investments Real Estate $100.00"
June 7, 2018 WPS Investments Real Estate $250.00
July 12 2018 PSA Investments Real Estate $100.00
June 10, 2018 WPS Housing Mortgage $1112.00

What I need help with is writing a formula that adds all the entries that meet the following criteria; Date falls in June, "ID" = "WPS", "item" = "real_estate".
so the forumla should equal $350.00. Im guessing this can be accomplished through using multiple if functions??

Thanks in advance

[Sam Capricci]

is each of these June 5, 2018 WPS Investments Real Estate $100.00 in one cell only? Or is the date in one cell, the WPS investments in another cell, real estate in another and the dollar figure in another cell?
A sample sheet might go a long way to getting you what you need.

[Webz2k]

date = a1, id = b1, item = c1 amount = d1 for example...

sumifs(d1:d10,a1:a10,"June",b1:b10,"WPS",c1:c10,"Real_estate")

Just change the ranges and criteria to what ever you need them to be. So d1:d10 is the sum range and the each range and the criteria for that range after that and it will give you a total for any rows that meet said criteras.

[CharismaticCity]

is each of these June 5, 2018 WPS Investments Real Estate $100.00 in one cell only? Or is the date in one cell, the WPS investments in another cell, real estate in another and the dollar figure in another cell?
A sample sheet might go a long way to getting you what you need.

apologies. but each entry is in its own cell

(a1) ( b1) (c1) (d1) (e1)
June 5 2018, WPS, Investments, Real Estate, $100.00

[Webz2k]

=sumifs(E:E,A:A,"June",B:B,"2018",C:C,"WPS",D;D,"Real_Estate")

[Sam Capricci]

this will work but you have to convert the dates to numbers
=SUMPRODUCT(($E$2:$E$13)*($A$2:$A$13 > 43251)*($A$2:$A$13 < 43282)*($B$2:$B$13="wps")*($D$2:$D$13="real estate"))
43251 is the equivalent of 5/31/2018 and 43282 is the equivalent of 7/1/2018
OR, you can point to cells with the date values in them like this...
=SUMPRODUCT(($E$2:$E$13)*($A$2:$A$13 > L2)*($A$2:$A$13 < L3)*($B$2:$B$13="wps")*($D$2:$D$13="real estate"))
where 5/31/2018 is in L2 and 7/1/2018 is in L3 for example.

EDIT: this should also work...
=SUMPRODUCT(($E$2:$E$13)*((TEXT($A$2:$A$13,"mmyyyy")="062018")*($B$2:$B$13="wps")*($D$2:$D$13="real estate")))

[CharismaticCity]

Ive attached an image of my sheet to clear up any cunfusion

[CharismaticCity]

tried this method and it seems it should work yet something is out of wack somewhere

[Sam Capricci]

first, which post are you responding to, mine or Webz2k's? Second, did you try my second formula?
=SUMPRODUCT(($E$2:$E$13)*((TEXT($A$2:$A$13,"mmyyyy")="062018")*($B$2:$B$13="wps")*($D$2:$D$13="real estate")))

I set up a sheet with your values in it and it works fine with those and returned 350 with all the functions I provided you.

Posting a snapshot will not help so the image in post #7 isn't showing us more than you gave us in posts 1 and 4.

if you post a workbook with actual (desensitized) data we can see where our formulas go wrong.
"something is out of wack somewhere" isn't helpful, what is the formula you are using and what is it returning?

[CharismaticCity]

first, which post are you responding to, mine or Webz2k's? Second, did you try my second formula?
=SUMPRODUCT(($E$2:$E$13)*((TEXT($A$2:$A$13,"mmyyyy")="062018")*($B$2:$B$13="wps")*($D$2:$D$13="real estate")))

I set up a sheet with your values in it and it works fine with those and returned 350 with all the functions I provided you.

Posting a snapshot will not help so the image in post #7 isn't showing us more than you gave us in posts 1 and 4.

if you post a workbook with actual (desensitized) data we can see where our formulas go wrong.
"something is out of wack somewhere" isn't helpful, what is the formula you are using and what is it returning?

I’ve tried your method and it worked perfectly. Thank you very much.