Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

Level 1

8 points

A cell which counts down from a 100 to zero

I'd like to create a cell that counts down from 100 to zero, as I have 100 checkboxes that are being checked off. How do I do this?

Posted on Jan 13, 2023 5:02 AM

Best reply

Level 8

35,396 points

Posted on Jan 13, 2023 6:04 AM

Try this.

Create a new document based on the 'Checklist Total' template at File > New in your menu.

Change the formula in C21 from:

=SUMIF(A,TRUE,C)

To:

=COUNTIF(A,FALSE)

The counts the number of checkboxes that have not been checked off yet.

Then add rows until you have 100 checkboxes.

The count will drop as you check boxes off.

View in context

Similar questions