Formula % checked boxes in row

Anja Smeets

I have 5 check box columns in a sheet and would like to show the percentage checked for the individual rows in the 6th column.

Column 6 should show 100% if all 5 columns in that row are checked, 80% if 4 columns in that row are checked, 60 % if 3 columns in that row are checked, etc.

What is the best formula to use?

Andrée Starå

Hi Anja,

Try this.

=COUNTIF([Col1]@row:[Col5]@row; 1) / COUNT([Col1]@row:[Col5]@row)   

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

=COUNTIF([Col1]@row:[Col5]@row, 1) / COUNT([Col1]@row:[Col5]@row)

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

Did it work?

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Anja Smeets

Thank you very much Andrée. This is exactly what I was looking for!

A fantastic week to you too.

Andrée Starå

Excellent!

Happy to help!

Best,

Andrée