How to Count Checked and Unchecked Boxes in Google Sheets (Khmer)

Hello everyone! Today I show you how to count checked and unchecked boxes and calculate completion percentage in Google Sheets step by step with easy formulas and video guide in Khmer language.

When you use checkboxes for task lists or project tracking, counting checked vs unchecked items helps you know exact progress instantly!

How Google Sheets Checkboxes Work

In Google Sheets:

• Checked box has value = TRUE
• Unchecked box has value = FALSE

Method 1: Count Checked Boxes Only

To count how many tasks are completed (checked):

Use COUNTIF formula with TRUE:

=COUNTIF(A2:A10, TRUE)

• Result: Returns total number of checked boxes (e.g. 7).

Method 2: Count Unchecked Boxes Only

To count how many tasks are still remaining (unchecked):

Use COUNTIF formula with FALSE:

=COUNTIF(A2:A10, FALSE)

• Result: Returns total number of unchecked boxes (e.g. 3).

Method 3: Calculate Completion Percentage (%)

To see completion progress percentage (e.g. 70%):

Divide checked count by total count:

=COUNTIF(A2:A10, TRUE) / COUNTA(A2:A10)

• Click Format ➔ Number ➔ Percent (%) (or click % button on toolbar).
• Result: Displays 70% progress!

Method 4: Show Dynamic Status Message with IF

You can show dynamic message like 7 of 10 Completed or All Finished 🎉:

=IF(COUNTIF(A2:A10, FALSE) = 0, "All Finished 🎉", COUNTIF(A2:A10, TRUE) & " of " & COUNTA(A2:A10) & " Completed")

📹 Watch Khmer Video Tutorial

Watch video step by step below to see how to count checked and unchecked boxes in Google Sheets:

💡 Quick Tip:

• Build Visual Sparkline Progress Bar: You can create a mini visual green progress bar in 1 cell! Use this formula: =SPARKLINE(COUNTIF(A2:A10, TRUE), {"charttype", "bar"; "max", COUNTA(A2:A10); "color1", "#107C41"})
• Don't Put Quotes Around TRUE/FALSE: In =COUNTIF(A2:A10, TRUE), write TRUE directly without quotes. If you write "TRUE", Google Sheets treats it as text string instead of boolean checkbox state!
• Count Checkboxes in Multiple Columns: To count checkboxes across columns A to D, write: =COUNTIF(A2:D10, TRUE).

📚 Related Resources

• How to Highlight Rows Automatically Based on Checkbox in Google Sheets
• How to Create Dynamic Drop-Down List in Google Sheets
• How to Split Text in Google Sheets (3 Easy Methods)
• Top 15 Basic Excel Formulas Every Beginner Should Know