Count Checkboxes and Percent Complete in Apple Numbers

Quick answer: Use actual checkbox cells for task status. Count checked tasks with COUNTIF, then divide by the number of real tasks. Do not use the number of preformatted checkbox cells as the denominator: an empty spare row is not an unfinished task.

Requirements and evidence

This guide targets Numbers for Mac 15.4, the edition identified by Apple’s Mac guide when checked on October 16, 2026. Check your installed version in Numbers → About Numbers. These are Mac instructions, not the iPhone, iPad or iCloud interface. English formulas below use commas; a document that uses decimal commas may require semicolons between arguments.

Testing disclosure: The instructions were checked against Apple documentation and the sample results were independently calculated. This workflow has not been tested in the Numbers application; no application screenshots are supplied.

Create a checklist with a known answer

Create a table named Tasks with one header row. Enter the following in A1:C9. Leave the final Task and Owner cells empty; the last row is deliberately spare. In column C, initially leave every body cell empty. “Checked” in the table below is an instruction for the next step, not text to paste into C.

Row	Task (A)	Owner (B)	Done (C)
2	Confirm venue	Alex	Checked
3	Approve budget	Sam	Checked
4	Send invitations	Alex	Unchecked
5	Confirm catering	Jo	Checked
6	Test projector	Sam	Unchecked
7	Print signs	Jo	Unchecked
8	Share agenda	Alex	Checked
9			Unchecked

There are seven real tasks and four completed tasks. The correct completion rate is 4 ÷ 7 = 57.142857…%, or 57.1% to one decimal place. Counting eight checkbox cells would incorrectly give 50%.

Add real checkboxes

1. Select C2:C9.
2. Click Format in the toolbar. In the sidebar, choose Cell → Data Format → Checkbox.
3. Select C2:C9 and press 0 to clear all checkmarks, then click C2, C3, C5 and C8 individually to select those four.
4. Leave C9 unselected. Do not type the words “Checked” or “TRUE” as text substitutes.

Apple documents selected checkboxes as true/1 and unselected checkboxes as false/0. It also documents 1 and 0 for setting a selection of checkboxes. Avoid using Space to reset a mixed selection: it toggles the selection based on its top-left cell. Apple: cell controls.

Put the summary outside the checklist

Use E1:F5 in the same Tasks table. This keeps the formulas below local and prevents the summary labels from becoming tasks.

Cell	Label or formula	Expected result
E1	Metric
F1	Result
E2	Checked boxes
F2	=COUNTIF(C2:C9,TRUE)	4
E3	Named tasks
F3	=COUNTIF(A2:A9,"<>")	7
E4	Completed named tasks
F4	=COUNTIFS(A2:A9,"<>",C2:C9,TRUE)	4
E5	Percent complete
F5	=IF(F3=0,0,F4/F3)	0.571428571…

Enter each formula by selecting its cell, typing =, and finishing with Return. Keep TRUE unquoted so it is the Boolean criterion. COUNTIFS applies both tests to the same row: there must be a task name and a checked status. See Apple’s COUNTIF and COUNTIFS references.

Select F5 and choose Cell → Data Format → Percentage in the Format sidebar; use one decimal place. Do not multiply the formula by 100 as well. The stored fraction 0.571428571… is already the appropriate input for percentage formatting. Apple: cell formats.

Apple’s IF reference describes selecting between two results. The zero-task result is a deliberate policy choice: this tracker displays 0% when there are no tasks. It does not mean a project with no defined scope has been completed. Use a separate “No tasks defined” label if that distinction matters in your reporting.

Test the denominator rather than trusting the display

Perform these reversible checks on the practice table:

1. Check the spare C9 box. F2 should rise to 5, but F4 should stay 4 and F5 should stay 57.1%. This is why F5 uses F4 rather than F2.
2. Type Book rehearsal into A9. There are now eight tasks and five completed tasks: 62.5%.
3. Uncheck C9. The result should become 50.0% (4 of 8).
4. Clear A9 and leave C9 unchecked to return to 57.1%.
5. In a separate practice copy, remove all task names. F3 and F4 should be zero; F5 should show 0%, without a division error.

A space-only task label is still content. A stray space in A9 can inflate your denominator. This example expects manually entered labels or genuinely empty cells; if task labels come from formulas, first check how their empty-string results interact with your chosen counting rule.

Maintain and troubleshoot the tracker

• The answer is 50% immediately: You probably divided by eight preformatted status cells. Count task labels instead.
• A spare checked row counts as completed: Use the two-condition numerator in F4. A raw checkbox count cannot distinguish an accidental checkmark from a task.
• Everything looks checked after pressing Space: Use 0 for an explicit reset, then recreate the four sample selections.
• New tasks do not change the result: These examples deliberately use bounded ranges. If you append tasks below row 9, extend all three source ranges together and add the Checkbox format to the new status cells. Check the first and last referenced row in every formula.
• A completed task seems to count twice: The unit is one row per task. Repeated task descriptions count as separate rows; deduplicate the work list if they represent the same obligation.
• You want effort-weighted progress: Seven tasks of unequal size do not become equal work just because each has a checkbox. This guide measures task count, not hours, cost or effort.

For the criteria mechanics, see COUNTIF and COUNTIFS. For the zero-denominator branch, see IF.