COUNTM & COUNTIF function

Rabia

Hi,

I'm trying to obtain a count of all the specific instances where I see "City of Staunton" in this particular column, but I'm a little stuck with which formula to use.

I want a count on this sheet

any help would be appreciated!

Rabia

Nevermind, I figured it out!

Andrée Starå

Hi @rabia

I hope you're well and safe!

Excellent!

Glad you got it working!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Please support the Community by marking your post with the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

CNC

Can someone share the answer to this question? I need a formula similar to this! Thank you!

Genevieve P.

Hi @CNC

When you're looking into a multi-select column, you'll want to use the HAS Function.

For example:

=COUNTIFS({Column with Multi}, HAS(@cell, "Value"))

Cheers,

Genevieve

CNC

This works great! Thank you!