Help with Count()

[Peter_Kalu]

Hello Team,

I have a number column that I want to use to count how many times a specific text appeared in a row. How may I go about doing this?

Thanks!

[Marc_Dillon]

Peter_Kalu:

count how many times a specific text appeared in a row

Like in ALL columns in the entire row? What is the make-up of your data? Would the text ever be in one column more than once? This may not be possible, but take a look at CONTAINS()

help.appsheet.com

CONTAINS()

Does text contain fragment?

Say you have 3 columns in a row, you can count how many of those columns contain the text via something like this:

IFS( CONTAINS( [col1] , text ) , 1 ) +
IFS( CONTAINS( [col2] , text ) , 1 ) +
IFS( CONTAINS( [col3] , text ) , 1 )

[Peter_Kalu]

Thanks, Marc. The columns I’m interested in are of type Enum, so selected text will not be repeated in a column, but could be in other columns within the row. Can Contains() function solve this?

[Marc_Dillon]

Peter_Kalu:

The columns I’m interested in are of type Enum

Ok, so CONTAINS is not necessary for that then.

IFS(  [col1] = text ) , 1 ) +
IFS(  [col2] = text ) , 1 ) +
IFS(  [col3] = text ) , 1 )