Count the number of times a value shows up in a column

darrink

For whatever reason, I cannot find the right syntax to create a formula that works to count the values in a given column. I'm trying to use it for a sheet summary.

I've been trying variations of this: =COUNT([Quote Validation Step]:[Quote Validation Step], [Denied])

I get #UNPARSEABLE

darrink

Nevermind... I figured it out. Rookie mistake...

Here's the correct syntax: =COUNTIF([Quote Validation Step]:[Quote Validation Step], "Denied")

darrink

Nevermind... I figured it out. Rookie mistake...

Here's the correct syntax: =COUNTIF([Quote Validation Step]:[Quote Validation Step], "Denied")

Andrée Starå

Hi @darrink

I hope you're well and safe!

Excellent! Glad you solved it!

Be safe and have a fantastic weekend!

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!