# How can I use a formula to count the total in a column that has specific values

Options

I am try to count the number of people who are internal coming to an event, so we have a form that people put in what their organization is. If it is internal, it should have Geisinger in the name, but there are many branches, so it could be Geisinger (insert campus names). I want to calculate how many people have Geisinger in the name of their organization without having to ask them if they're internal or external.

This is the formula I have so far-

=COUNTIF(CONTAINS("Geisinger", Organization:Organization), "True")

I keep getting an error. Any ideas?

Thanks!

Tags:

• ✭✭✭✭✭✭
edited 02/20/20
Options

I would make a helper column, that has the formula =IF(CONTAINS("Geisinger", Organization3), 1, 0). then run a count formuala for that range for 1's =COUNTIF(Internal:Internal, true). the count if could also be put into the sheet summary that would be cleaner.

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!