# How to sum values where the checkbox is checked in Google Sheets

Use SUMIF with TRUE as the criterion: `=SUMIF(C2:C9,TRUE,B2:B9)` adds the amounts on ticked rows.

**Google Sheets:** `=SUMIF(C2:C9,TRUE,B2:B9)`

**Excel:** The same SUMIF works with Excel's checkboxes in Microsoft 365, which also store TRUE and FALSE.

## Example

Sample data (row 1 is the header):

| A | B | C | D | E |
| --- | --- | --- | --- | --- |
| Expense | Amount | Reimbursed |  | Paid back |
| Flight | 412.5 | true |  |  |
| Hotel | 286 | true |  |  |
| Taxi | 38.2 | false |  |  |
| Dinner | 64.75 | true |  |  |
| Conference fee | 499 | false |  |  |
| Parking | 22.9 | true |  |  |
| Train | 47.3 | false |  |  |
| Lunch | 18.6 | true |  |  |

Formula in E2: `=SUMIF(C2:C9,TRUE,B2:B9)`

Result: $804.75

## How it works

SUMIF checks each cell in `C2:C9` for TRUE, a ticked box, and adds the amount on the same row: 412.50 + 286 + 64.75 + 22.90 + 18.60 = 804.75. Unticked boxes hold FALSE, so their amounts are left out, and ticking one more box updates the total at once.

## Other ways

- `=SUMIF(C2:C9,FALSE,B2:B9)`: Sum the unticked rows: what is still owed. (The amounts not yet reimbursed: $584.50.)
- `=SUMPRODUCT(B2:B9*C2:C9)`: TRUE counts as 1 and FALSE as 0 in multiplication, so this works too.

## Common mistakes

- Putting TRUE in quotes, `"TRUE"`, still works in SUMIF, but in other formulas text "TRUE" isn't the same as the value TRUE.
- The sum range and the checkbox range must be the same size and start on the same row.

## Questions

**How do I sum checked rows for one category?**

Use SUMIFS: `=SUMIFS(B2:B9,C2:C9,TRUE,A2:A9,"Hotel")`.

**Can I list the checked rows?**

Use FILTER: `=FILTER(A2:B9,C2:C9)`, since the checkboxes are already TRUE and FALSE.

Every formula and result on this page was checked by running it in the Spreadsheet Practice formula engine on 2026-10-30.

Source: https://spreadsheetpractice.com/formulas/sum-where-the-checkbox-is-checked