Forum Question: How Do I Add To a “Total” Cell a Certain Value If a Checkbox Is TRUE?

Imagine a spreadsheet with each row consisting of a “Name” field followed by a series of checkboxes and ended with a “Total” field. If each of the checkboxes is checked, then a certain amount is added to the total field. So, each checkbox can add a specific amount to the total if checked. How can I implement this?

Comments: One Response to “How Do I Add To a “Total” Cell a Certain Value If a Checkbox Is TRUE?”

    4/1/18 @ 9:11 pm

    What you need is the SUMIF function. So say column A has the names. Cells B2, C2 and D2 have the values you want to add if checkboxes are checked. The rest of the columns B, C and D have checkboxes. Column D, starting with D3 has the formula SUMIF(B3:D3,TRUE,$B$2:$D$2). This simply looks at B3, C3 and D3 and if any is true then the amounts in B2, C2, and D2 are added to the total that then appears in D3. The $ symbols mean that as you paste the formula in D3 into D4 and beyond, that those references stay on those cells, while the B3:D3 part will adjust for each row.

Comments Closed.