Single drop down 3 selection ( open, closed, cit). How do write formula to count each in column?

Mike Boyer

Status - Column Heading

Open - Drop Down

Closed - Drop Down

CIT - Drop Down

Wanting to count how many "open"

Andrée Starå

Hi Mike,

Try something like this.

=COUNTIF(Status:Status; "Open")

The same version but with the below changes for your and others convenience.

=COUNTIF(Status:Status, "Open")

Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.

Did that work?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!