Counting/Sum Formula for check boxes AND numbers in a column

A few ways are available with slightly different results

=COUNTIFS(B,"<>"&FALSE,B,"<>")

Counts all cells that are not FALSE and not blank. It counts all cells that have anything in them other than FALSE. This includes numbers and text and dates and all.

=COUNTIF(B,TRUE)+COUNT(B)

Counts all cells that are TRUE and all cells with numeric values. Numeric values are numbers, dates, durations but does not include boolean TRUE/FALSE.

=COUNTIF(B,TRUE)+COUNTIF(B,">=0")+COUNTIF(B,"<0")

Counts all TRUE and all numbers. Ignores all other data types. It will give a blue warning triangle if there is a date or duration anywhere in column B.

I am sure there are additional ways if none of these meet your needs.

You are correct. I took "total of the count of TRUE checkboxes AS WELL AS the total of the listed numbers" to be the count of the checkboxes + count of the numbers. Reading it now it is obvious you want the count of the checkboxes + the SUM of the numbers. Try this instead:

=COUNTIF(C3:C124,TRUE)+SUM(C3:C124)

This will work as long as there are only numbers, checkboxes, and text. Durations and dates will cause problems.

It would help if you could post of screenshot of your table. shift-command-4, drag to select area with the "crosshairs", release, then start a new post here and insert the screenshot image from the Desktop using the "mountains and moon" icon below.

SG

Thanks for the screenshot. So what are you now trying to do with this table.

(Curious why you have all those mostly blank rows. This doesn't look like the kind of Numbers table one normally sees. Check out the templates at File > New in your menu to see examples of "Numbers style" tables. 'Checklist Total' is somewhat similar to yours.)

SG

COUNT and COUNTIF are different functions.

COUNTIF(C3:C124,true) will count the rows in column C where the checkbox has been checked.

The ( following the first COUNT is not needed—the concave end of the COUNT token represents the required opening parenthesis for a function. When changing the first COUNT to COUNTIF, delete the ( before C3. The ) following true; will change shape to match the ;crescent moon shape of the two parentheses at the end of the formula ( and one of those two will change to the ) form, and may be deleted. (leaving it in place will likely result in an error message).

The + sign and the part of the formula after it (except for the extra ) ) is good as it stands.

Regards,

Barry

COUNT counts only cells which contain numbers or quasi numeric values.

COUNT(C3:C124 will count the number values in the named range of cells.

"As you can see in the example below,

I have 27 boxes checked, and the number 6 one of the included cells,

and yet my total (bottom left of image) is 28, not 33"

That is a correct result for the formula you show in the same post.

COUNTIF(C3:C124,true) counts the number of checkbox cells that are checked (27)

COUNT(C3:C124)            counts the number of cells containing a number           ( 1)

27 + 1 = 28

See Badunit's post above for a formula that counts the checked boxes and sums the numbers in the cells in the specified range.

Regards,

Barry

I assume that the cell containing a zero is the cell where the count should appear.

What is the formula in this cell?

What is the expected result?

Regards,

Barry

Did you change all the B's in the formula to whatever column your checkboxes are in?