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.



  • Heather Duff
    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!



  • 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.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!