COUNTIFS and OR statement together?
I have several countifs together and I need to add another set ("Status" column that states "not started" or "in progress"). Everything I've tried has not worked.
=COUNTIFS({Vendor Category}, $[Primary Column]@row, {Help}, "assistance needed", {status}, "not started OR "in progress")
Best Answer
-
Hi Jessica,
I did a little testing:
This is what I used:
=COUNTIFS([Column2]1:[Column2]7, "assistance needed", Status1:Status7, OR(@cell = "not started", @cell = "in progress"))
What worked for me was adding this in the criteria for status:
OR(@cell = "not started", @cell = "in progress")
Which in your case might be:
=COUNTIFS({Vendor Category}, $[Primary Column]@row, {Help}, "assistance needed", {status}, OR(@cell = "not started", @cell = "in progress"))
Hope it helps,
Samantha
Answers
-
See below proper syntax:
=COUNTIFS({Vendor Category}, $[Primary Column]@row, {Help}, "assistance needed", {status}, or(@cell="not started", @cell="in progress"))
-
Hi Jessica,
I did a little testing:
This is what I used:
=COUNTIFS([Column2]1:[Column2]7, "assistance needed", Status1:Status7, OR(@cell = "not started", @cell = "in progress"))
What worked for me was adding this in the criteria for status:
OR(@cell = "not started", @cell = "in progress")
Which in your case might be:
=COUNTIFS({Vendor Category}, $[Primary Column]@row, {Help}, "assistance needed", {status}, OR(@cell = "not started", @cell = "in progress"))
Hope it helps,
Samantha
-
This did the trick! THANK YOU! working in formulas all morning my brain just could not get this syntax correct.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!