Can you use CountIF if there is more than one term in a cell?
tcanelli41471
✭✭✭✭
I have a sheet that is updated from an export from another system. One of the fields in the other system is for category and can have more than one category selected. So when the data exports it appears in Smartsheet as "Category 1, Category 2" - separated by a comma.
I want to count all the rows with Category 1.
Is there a formula to do that?
Answers
-
You'll want to use a CONTAINS or a FIND inside your COUNTIF.
Something like this....
=COUNTIF(Range:Range, FIND("Search Value", @cell) > 0)
Kelly Drake (she/her/hers)
STARBUCKS COFFEE COMPANY| business optimization product manager
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!