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

Tatem Wertman

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!

Paul Newcome

Very close actually...

=COUNTIFS(Organization:Organization, CONTAINS("Geisinger", @cell))

Paul Newcome

Very close actually...

=COUNTIFS(Organization:Organization, CONTAINS("Geisinger", @cell))

RossL

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.