Getting a total in a column of check boxes

Thomas J Ehid

Thank you in advanced!!

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?

Mark Cronk

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

Mark Cronk

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

Thomas J Ehid

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?

Mark Cronk

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

Thomas J Ehid

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

Mark Cronk

Ah, you count checkboxes not sum them. Try:

=COUNTIF(complete:complete, 1)/389

Work?

Mark

Thomas J Ehid

your a rock star !! thanks....

here is what worked.

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

Mark Cronk

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