Expaning Countif to include an additional criterion

Sue Vaeth

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

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