## Sum cells with check boxes

*Article updated on February 26, 2018*

I will now demonstrate with the following table how to add check-boxes and sum enabled check-boxes using a formula.

#### Add check boxes to worksheet

The following animated image shows you how to quickly insert and position a check box, then easily copy and paste it to cells below.

The picture above doesn't show you how to link check boxes and hide linked cell values, detailed instructions below:

Select cell B3. Go to tab "Developer" and and click "Insert" button and then "Check boxes (form control)".

Draw a check box in cell B3. Remove check box text. Use arrow keys to position checkbox 1 px incrementally.

Click and hold with left mouse button black box in the bottom right corner of cell B3.

Drag down as far as needed, in this example to cell B10.

The following article shows you a template that allows you construct multi-level to-do lists:

Multi-level To-Do list template

Today I will share a To-do list excel template with you. You can add text to the sheet and excel creates […]

#### Link check boxes to cells

Right click on check box in cell B3, click "Format Control..."

Click on Cell link: field and select cell A3, click OK button.

Repeat this with check box in cell B4 and select cell link cell A4.

Now repeat this with remaining check-boxes in cell range B5:B10.

#### Hide values in cell range A3:A10

Select cell A3:A10. Press CTRL + 1.

Click "Custom" category, see picture above. Type ;;; in type field, see picture above. Click OK button.

Recommended article:

Have you ever seen dashboards where you can click a shape and a picture shows up. If you click it […]

#### Build formula

Double click cell C12. Type:

Recommended article:

The SUM function in Excel allows you to add values, the function returns the sum in the cell it is […]

Create an array formula, see instructions below.

- Press CTRL + SHIFT simultaneously
- Press Enter once
- Release all keys

If you did this right the formula now has a beginning and ending curly bracket, like this: {=SUM(A3:A10*D3:D10)}

Don't enter these characters yourself, they appear automatically.

Check a few check boxes to verify that the formula is working.

If you don't like array formulas, use this formula:

#### Download excel *.xlsx file

Count how many times a string exists in a cell range (case insensitive)

Question: How do I count how many times a word exists in a range of cells? It does not have […]### 2 Responses to “Sum cells with check boxes”

### Leave a Reply

**How to add a formula to your comment:**

<code>your formula</code>

Remember to convert less than and larger than signs to html character entities before you post your comment.

**How to add VBA code to your comment:**

[vb 1="vbnet" language=","]

VBA code

[/vb]

**How to add a picture to your comment:**

Upload picture to postimage.org

Add picture link to comment.

**Contact Oscar**

You can contact me through this webpage

Great Tutorial Oscar! I'm using the check box in an Excel sheet thanks to you. Just wondering, is there a way to multiply the values in column C, rows 1 through 5 by any value I chose? Say row 1, when checked, could be multiplied by a value of 2 and row 4 when checked multiplied by a value of 5. If I could add the ability to select "quantities of" for each row that'd be great.

Randal,

Yes, it is possible. If column D in the example above contains quantities the formula in cell C8 becomes:

=SUMPRODUCT(($B$1:$B$5=TRUE)*$C$1:$C$5*$D$1:$D$5)