How do I 'Total' the checkboxes in a Column using Numbers.

Each checkbox has the value TRUE (checked) or FALSE (unchecked). What you are looking for is a COUNT od the checked boxes, rather than a SUM.

If row 22 (where the count is to appear) is a Footer row, use this formula:

=COUNTIF(B,TRUE)

If Row 22 is not a Footer row, you will have to specify the cell range:

=COUNTIF(B2:B21,TRUE)

Regards,

Barry

Buddy,

Generally since you are posting a new question you should start a new thread. You can always paste the link to this thread in your new post to indicate what you have already reviewed. In addition it is a good idea to show what you have done so we see:

1) what you arrangement and presentation is

2) the formulas you are trying to use.

in your case countif() will not work. you want to use the function sumif() like:

row 10 is a footer row which can make by selecting the number of footer rows you want in the table inspector:

C10=SUMIF(B, TRUE, C)

I tried several of these solutions and not working very well. Perhaps I didn't write down the formula correctly. I have some check boxes on one column (C) and values on another column (D). I want to sum only those which have check marks and place the sum on bottom of column D. Anyone know the formula for this?

Sounds like you might have the cell's format set to Text. Use the Inspector to change it to Automatic.

Regards,

Barry

If the check boxes are in column A and the values are in column B, the formula would be:

=SUM(A, TRUE, B).

Regards,

Jerry