How to Sum If Checkbox is Checked in Google Sheets

To sum values in Google Sheets based on whether a checkbox is checked, you can use the SUMIF function. Here's a step-by-step guide on how to do this:

1. First, organize your data with the checkboxes and values in separate columns. For example, place the checkboxes in column A and the values in column B.
2. In an empty cell where you want the sum to appear, type the following formula:

=SUMIF(A:A, TRUE, B:B)

This formula checks if the checkboxes in column A are checked (TRUE) and sums the corresponding values in column B.

3. Press 'Enter' to see the sum of the values with checked checkboxes.

Example

|   A   |   B   |   C   |
|-------|-------|-------|
| [ ]   |  100  |       |
| [x]   |  200  |       |
| [x]   |  300  |       |
| [ ]   |  400  |       |
| [x]   |  500  |       |
|-------|-------|-------|
|       |       | 1000  |

1. In the example above, checkboxes are in column A and values are in column B.
2. In cell C7, type the formula =SUMIF(A:A, TRUE, B:B) and press 'Enter'.
3. The sum of the values with checked checkboxes (200 + 300 + 500) will appear in cell C7, which is 1000.