Countifs with multiple choices in one row AND one choice in another row
Greetings:
Im trying to narrow down a count based if one of several choices in one column PLUS only one specific choice in another column
=COUNTIFS([Status:Status], "Discharged") + COUNTIFS([Status:Status], "Lost to Follow-up") + COUNTIFS([Status:Status], "Follow-up completed") + COUNTIFS([Status:Status], "Deceased"),CONTAINS([Provider:Provider], "Cherian")
I think I need to change the phrasing of the one specific choice in last part in bold.
how should I phrase this?
Appreciate help!!
Answers
-
Try the below:
=COUNTIFS(Status:Status, OR(@cell = "Discharged", @cell = "Lost to Follow-up", @cell = "Follow-up completed")) + COUNTIFS(Status:Status, @cell = "Deceased", Provider:Provider, CONTAINS("Cherian", @cell))
-
@Leibel S Im not sure why, but its not working.
Why put the deceased phrase on the other side of the previous phrase containing the list choices?
-
What exactly do you want to count?
Is the formula giving you an error or just not the result you wanted?
-
I want to count those rows that have Cherian in Provider column
AND
any of the following in the Status column:
Discharged; Follow-Up Completed, Lost to follow-up OR Deceased.
-
The below would match what you describe
=COUNTIFS(Status:Status, OR(@cell = "Discharged", @cell = "Lost to Follow-up", @cell = "Follow-up completed"),Provider:Provider, CONTAINS("Cherian", @cell))
-
Thank you! Yes, this worked! Appreciate your guidance!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!