Forum Discussion
CountIFS/SumIFS Question
Hello everyone,
I'm working with a lot of data, and trying to find a way to add quantities already in the sheets but spread out over 500 or more rows. I'm not able to change how the data is delivered to me, as it's a downloaded file from a 3rd party.
Here's a sample of what I'm looking at:
| A | B | C | D |
| Plain Bagel | 7 | ||
| Plain Bagel | Bagel Spreads | Cream Cheese | 5 |
| Plain Bagel | Bagel Spreads | Butter | 2 |
| Plain Bagel | Toasted/Warmed | Yes Toasted/Warmed | 7 |
| Double Espresso | Food Selection | Plain Bagel w/ Cream Cheese | 4 |
| Hot Chai Latte | Food Selection | Plain Bagel w/ No Spread | 2 |
| Iced Coffee | Food Selection | Plain Bagel w/ Butter | 6 |
Basically, I'm trying to add the numbers in column "D," but only if these requirements are met: If column A says Plain Bagel, column's B and C have to be empty. If column C has any type of Plain Bagel, then those should also be added.
In case it's needed: I'm currently using Excel for the web, but I do have access to the desktop version as well.
1 Reply
maybe try:
=SUMIFS(D1:D999, A1:A999, "Plain Bagel", B1:B999, "", C1:C999, "") + SUMIFS(D1:D999, C1:C999,"*Plain Bagel*")
