Countif Contains. Trying to sum "No" but picking up "Not" into account.

Renat

Countif Contains. Trying to sum "No" but picking up "Not" into account. 

What should I change in order to pick "No" only.

Thank you

Genevieve P.

Hi @Renat

Could you post screen captures of your current sheet with example data? I'd like to see what types of columns you're using.

If you're evaluating multi-select fields, you can use the HAS Function instead of Contains. That will look for an exact match.

Try:

=COUNTIF([1. Select Date]@row:[Person Completing the Form]@row, HAS(@cell, "No"))

Cheers,

Genevieve

Renat

=COUNTIF([1. Select Date]@row:[Person Completing the Form]@row, CONTAINS("No", @cell))

Genevieve P.

Hi @Renat

Could you post screen captures of your current sheet with example data? I'd like to see what types of columns you're using.

If you're evaluating multi-select fields, you can use the HAS Function instead of Contains. That will look for an exact match.

Try:

=COUNTIF([1. Select Date]@row:[Person Completing the Form]@row, HAS(@cell, "No"))

Cheers,

Genevieve

Renat

Hi Genevieve,

Thank you, all fixed now.

Regards

Renat