Count Ifs Question

Estufa

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"?

Nic Larsen

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

LookW

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))

Nic Larsen

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

LookW

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))