Expaning Countif to include an additional criterion
I have successfully created a countif formula to count the number of times a word appears in a column.
=COUNTIF([Medicaid Enrollment Status]4:[Medicaid Enrollment Status]158, "Enrolled")
Now I need to expand it to include an additional criterion, "Enrolled-Provisional"
I want to count all incidences in the column called Medicaid Enrollment Status for all rows for "Enrolled" and :Enrolled-Provisional". I'd also like to make this so I can keep adding rows without having to change the formula.
Thanks
Answers
-
Hi Sue,
You could try this:
=COUNTIF([Medicaid Enrollment Status]:[Medicaid Enrollment Status], "Enrolled")+COUNTIF([Medicaid Enrollment Status]:[Medicaid Enrollment Status], "Enrolled-Provisional")
Taking out the cell numbers after [Medicaid Enrollment Status] allows you to select the entire column.
Hope this helps!
Best,
Heather
-
Thank you so much. That worked. I tried using the + but didn't include the full formula and got an unparsable error. And thanks for the tip about all rows. I'm going to fix that on all of my formulas.
Sue
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 348 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!