SUMIF sum of the number of cells meeting a text condition

Julietteenherbe

I'd like to add up the number of boxes with the same condition. For example, in column 1 I would like to count how many times I have the word nature. When I use SUMIF to do this it doesn't works.

Protonsponge

Hello @Julietteenherbe,

I have detailed a couple of options that might work for you below.

Option 1 - If your column will have the word "Nature" on its own in a cell, the following will count the number of cells if it is equal to "Nature"

=COUNTIF([Column2]:[Column2], "Nature")

Option 2 - If your column will contain the word "Nature" among other text, it might be more effective to include the use of the CONTAINS function to count if the cell contains the word "Nature" somewhere in the cell as per the example below.

=COUNTIF([Column2]:[Column2], CONTAINS("Nature", @cell))

I hope that is helpful to you in some way,

Protonsponge

Protonsponge

Hello @Julietteenherbe,

I have detailed a couple of options that might work for you below.

Option 1 - If your column will have the word "Nature" on its own in a cell, the following will count the number of cells if it is equal to "Nature"

=COUNTIF([Column2]:[Column2], "Nature")

Option 2 - If your column will contain the word "Nature" among other text, it might be more effective to include the use of the CONTAINS function to count if the cell contains the word "Nature" somewhere in the cell as per the example below.

=COUNTIF([Column2]:[Column2], CONTAINS("Nature", @cell))

I hope that is helpful to you in some way,

Protonsponge

Julietteenherbe

Awesome it works, thanks a lot