Table of Contents
Google Sheets is a powerful tool that allows users to create and manipulate spreadsheets. One useful feature is the ability to sum a column based on the status of a checkbox. This means that the sum of a certain column will only include values from rows where the checkbox is checked. To use this feature, simply select the cells you want to include in the sum, and then use the “SUMIF” function followed by the criteria of the checkbox being checked. This will provide an accurate sum of the selected column, taking into account only the rows that meet the specified condition. With this functionality, users can efficiently organize and analyze their data in Google Sheets.
Google Sheets: Sum If Checkbox is Checked
You can use the following formula to sum values in Google Sheets if a corresponding checkbox is checked:
=SUM(ARRAYFORMULA(A2:A11*B2:B11))This particular formula assumes that the values are in the range A2:A11 and the checkboxes are in the range B2:B11.
The following example shows how to use this formula in practice.
Example: Sum If Checkbox is Checked in Google Sheets
Suppose we have the following dataset in Google Sheets:
Note: You can add checkboxes to a range of cells by selecting a range, then clicking the Insert tab, then clicking Checkbox.
We can use the following formula to sum only the values in column A where the corresponding checkbox in column B is checked:
=SUM(ARRAYFORMULA(A2:A11*B2:B11))The following screenshot shows how to use this formula in practice:
The sum of the values in column A where the corresponding checkbox in column B is checked is 172.
We can confirm this is correct by manually calculating the sum of the values in column A where the corresponding checkbox in column B is checked:
Sum of Checked Checkboxes: 20 + 29 + 26 + 31 + 51 + 15 = 172
This matches the value that we calculated using the formula.
Cite this article
stats writer (2024). How do I use Google Sheets to sum a column based on whether a checkbox is checked?. PSYCHOLOGICAL SCALES. Retrieved from https://scales.arabpsychology.com/stats/how-do-i-use-google-sheets-to-sum-a-column-based-on-whether-a-checkbox-is-checked/
stats writer. "How do I use Google Sheets to sum a column based on whether a checkbox is checked?." PSYCHOLOGICAL SCALES, 26 Jun. 2024, https://scales.arabpsychology.com/stats/how-do-i-use-google-sheets-to-sum-a-column-based-on-whether-a-checkbox-is-checked/.
stats writer. "How do I use Google Sheets to sum a column based on whether a checkbox is checked?." PSYCHOLOGICAL SCALES, 2024. https://scales.arabpsychology.com/stats/how-do-i-use-google-sheets-to-sum-a-column-based-on-whether-a-checkbox-is-checked/.
stats writer (2024) 'How do I use Google Sheets to sum a column based on whether a checkbox is checked?', PSYCHOLOGICAL SCALES. Available at: https://scales.arabpsychology.com/stats/how-do-i-use-google-sheets-to-sum-a-column-based-on-whether-a-checkbox-is-checked/.
[1] stats writer, "How do I use Google Sheets to sum a column based on whether a checkbox is checked?," PSYCHOLOGICAL SCALES, vol. X, no. Y, ص Z-Z, June, 2024.
stats writer. How do I use Google Sheets to sum a column based on whether a checkbox is checked?. PSYCHOLOGICAL SCALES. 2024;vol(issue):pages.