COUNTIF Question

Hello


We have a sheet that contains variations of words in a multi select column.

For example; Lisa, Lisa 1, Lisa 2.

I am trying to count how many times the word Lisa appears, regardless of the variation, i.e. Lisa 1 or Lisa 2.

I've tried lots of different formulas but nothing is working;

=COUNTM({Status Range 1}, ="Lisa", @cell)

=COUNTIF({Status Range 1}, CONTAINS("Lisa", @cell))

Can anyone help?

Many thanks

Lisa

Tags:

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!