Countif and Has returning 0 from multi value cells

Flavio Tincani

I have a column that has the option to have multiple values.

I created a calculation sheet so I can use the data in a dashboard, so I need to count the number of "GovDoc" and the other values but it keep returning 0

I'm using the following formula

=COUNTIF({Issues}, HAS({Issues}, "GovDoc"))

What is wrong?

Flavio Tincani

It worked with the @cell function!

Thanks!

Lucas Rayala

Hi @Flavio Tincani, you have this set up like a summif (range, criteria range 1, criteria 1) instead of countif (criteria 1, range 1). Also, you can't put a function around your range. Try this:

=COUNTIF({Issues}, CONTAINS("GovDoc", @cell))

Good luck!

Flavio Tincani

It worked with the @cell function!

Thanks!

Lucas Rayala

Hi @Flavio Tincani glad it worked!