Checkbox adding

Hi orangeninja29

A table with one header row, one header column and two footer rows

Formula in footer cell B10: SUM(B)

Formula in footer cell B11: SUMIF(C,"FALSE",B)

Please call back with questions.

Regards,

Ian

Your table has some confusing points.

What is the error flagged by the error triangle in C11?

B11 is selected, but shows neither content nor a formula. Is that correct?

A10 contains a label: Total. The same row in column C contains an unchecked checkbox. Does this mean that the 'Total' in B10 is to be included in the total to be placed in B11?

Is 1189.49 the total on all values in B2:B9 or the total of the checked rows in B2:B9?

Assumptions:

B10 contains the total of ALL cells in the range B2:B9.

C10's checkbox format is an error. The cell's data format should be left as Automatic, or set to text.

B11, given the sample data and assuming that C2 is checked, should contain the total of values in B6 and B9.

Going on those assumptions, do this:

Convert Rows 11 and 10 to Footer rows. This makes it possible to use 'full column references for the SUM formula n B10 and the SUMIFS portion of the formula in B11.

B10: SUM(B)

"B" is a reference to all

B11: shown below table

Regards,

Barry

Have a look at the 'Checklist Total' template. It is a working example of what you describe. You can study it and incorporate the method into your own table. Or just use it as the starting point.

SG