COUNTIF multidrop down values

brallen

I am trying to create a summary sheet to give me the number of values in a multi drop down list. I need the exact match. I used this formula, but it's coming back #unparseable.

=COUNTIF([KSK Middle/High Testing Dates]:[KSK Middle/High Testing Dates], HAS(@cell, "October 7, 2024))

Matt Lynn ACT

@brallen an initial look, the first thing that jumps out is that you're not closing your criteria with a " symbol.

So you need to put a " between 2024 and the ).

Matt Lynn ACT

@brallen an initial look, the first thing that jumps out is that you're not closing your criteria with a " symbol.

So you need to put a " between 2024 and the ).

brallen

@Matt Lynn-PCG YOU ROCK! I knew it was something I was missing. That was the issue. Thanks bunches.