# Getting a total in a column of check boxes

I have a list of tasks, as they are completed I've requested the tech's to check a box that will make it "Completed". There are a total of 389 tasks. is there a formula that can add the "Completed" column and then divide it by 389?

• ✭✭✭✭✭✭

Excellent. Glad you found an solution. Please accept an answer to close the discussion. Thank you for contributing to the Community. Happy to help anytime.

Mark

I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.

• ✭✭✭✭✭✭

Hi Thomas,

Try placing this formula someplace besides the complete column. It will work as a summary sheet field.

=SUMIF(complete:complete, @cell=1)/389

Work?

Mark

I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.

• Thank you very much the formula works if I enter a 1. I would prefer to use a checkbox. Would you know how to make add up for a checkbox?

• ✭✭✭✭✭✭

Good afternoon,

The value of a checked checkbox is 1. The value of an unchecked checkbox is 0. If you set the column as checkbox the formula should work for you.

Help?

Mark

I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.

• Here is what I have, and I'm getting a 0

• ✭✭✭✭✭✭

Ah, you count checkboxes not sum them. Try:

=COUNTIF(complete:complete, 1)/389

Work?

Mark

I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.

• your a rock star !! thanks....

here is what worked.

=COUNTIF(Completed:Completed, @cell = 1) / 389

• ✭✭✭✭✭✭