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

Find more posts tagged with

Accepted answers

All comments

Heather Duff

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

Sue Vaeth

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

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.