Count the ticked checkboxes
A Google Sheets formula exercise from Sheetsdrill. Solve it with a formula bar on a live sheet in your browser, and it is checked the moment you submit.
The task
Column B is a checkbox column: a ticked box holds TRUE and an empty one holds FALSE. Count the ticked tasks in E1, and work out the share of all eight tasks that are ticked in E2.
What this exercise teaches
A checkbox is a cell that holds TRUE or FALSE, so every counting function can read it. Dividing by COUNTA of the task names keeps the share right when tasks are added.
A hint if you get stuck
COUNTIF(B2:B9, TRUE) counts the ticked boxes. TRUE is written without quotes. Divide by the number of tasks for the share.
Try it now, free, no account needed
Your first 15 exercises on Sheetsdrill are free. Open it on the practice page, solve it, and get instant feedback with a hint. A free account adds the worked solution; Pro unlocks every exercise, timed mode and the certificate.
Open this exercise