Adding prices in a column if there are multiple statuses identified
Hi Everyone,
I have no training in formulas and am only self taught. I cannot seem to figure out how to create a code for this situation, thank you in advance for your help!
I would like the formula to add up the dollar values of one column when there are certain statuses selected in a second column, and also is identified as Q1 in a third column. I tried to build the formula and got 'unparseable":
=SUMIFS({Tracker Range 1}, ({Tracker Range 2}, "Approved", OR("Postponed", ({Tracker Range 3}, "Q1"))))
Best Answer
-
Hi Alex,
You're doing great! You're very close. Let me make sure I understand what you want:
Add the items in Tracker Range 1 that meet the following criteria: Tracker Range 2 equals either Approved or Postponed, AND Tracker Range 3 equals Q1.
If so, it would look like this:
=sumifs({tracker range 1}, {tracker range 2}, OR(@cell="Approved",@cell="Postponed"), {tracker range 3}, "Q1")
Let me know if it works!
Best,
Heather
Answers
-
Hi Alex,
You're doing great! You're very close. Let me make sure I understand what you want:
Add the items in Tracker Range 1 that meet the following criteria: Tracker Range 2 equals either Approved or Postponed, AND Tracker Range 3 equals Q1.
If so, it would look like this:
=sumifs({tracker range 1}, {tracker range 2}, OR(@cell="Approved",@cell="Postponed"), {tracker range 3}, "Q1")
Let me know if it works!
Best,
Heather
-
OMG Thank you! I am so excited to get a response, this community is great. This is exactly what I was looking for thank you for your help.
Alex
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 472 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!