Count Ifs Question
Hi Community,
I want to use the countifs formula on a column that has multiple values (Ex: Apple, Banana, Pear). The cell is not restricted to one value, so some cells have multiple of the 3 values.
When I use the countifs for "Pear", the formula is counting cells that contain ONLY "Pear". Is it possible to alter the formula so it counts ANY cell that contains "Pear"?
Best Answers

Use the CONTAINS function, CONTAINS("Pear", @cell)

Yes! Super simple, use a countif(contains()) function! Here is one I used. I used an @row and @cell but it is just referencing one of the many smart unit features I have.
=COUNTIF([Smart Unit Features]$16:[Smart Unit Features]$99, CONTAINS([Smart Unit Features]@row, @cell))
Answers

Use the CONTAINS function, CONTAINS("Pear", @cell)

Yes! Super simple, use a countif(contains()) function! Here is one I used. I used an @row and @cell but it is just referencing one of the many smart unit features I have.
=COUNTIF([Smart Unit Features]$16:[Smart Unit Features]$99, CONTAINS([Smart Unit Features]@row, @cell))
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 62.2K Get Help
 358 Global Discussions
 198 Industry Talk
 427 Announcements
 4.4K Ideas & Feature Requests
 135 Brandfolder
 127 Just for fun
 128 Community Job Board
 444 Show & Tell
 28 Member Spotlight
 1 SmartStories
 283 Events
 35 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!