Checkbox

3 lessons in order

Learn how to count checked and unchecked checkboxes in Google Sheets using COUNTIF, COUNTIFS, ARRAYFORMULA, and Apps Script methods.

Learn how to apply conditional formatting to checkboxes in Google Sheets to highlight rows, due dates, and automate with Apps Script.

Learn how to sum values in Google Sheets when a checkbox is checked using SUMIFS, FILTER, ARRAYFORMULA with IF, and the QUERY function.