How to count Checkmarks in a column

LM gruppen · 08/27/19

Is there any body that can help me with - how to setup " How to count Checkmarks in a column " I have a lt of columns which a need to have a total count of - In the top of the sheet or in the bottom.

Thanks Søren Knudsen - Denmark

Andrée Starå · 08/27/19

Hi Søren,

I'd be happy to help!

Do you just want to know how to set up the formula(s) or do you want help to structure it?

Can you describe your process in more detail and maybe share the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@workbold.com)

Hope that helps!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

Andrée Starå · 08/27/19

Try something like this if it's the same column.

=COUNTIF(Checkbox:Checkbox; 1) + ""

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

=COUNTIF(Checkbox:Checkbox, 1) + ""

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

Did it work?

Hope that helps!

How to count Checkmarks in a column

Comments

Categories