Counting # of checked boxes in one column

c.marie

Hi all,

I've tried a few different formulas but can't figure out how to count the # of checked boxes in a column. My column is labeled "Approved" and has 131 cells, so I tried:

 =COUNTIF(approved1:approved131, 1)

But I'm getting #BOOLEAN EXPECTED

Paul Newcome

That particular error means the formula is in a specific type of column (Date, Number, Symbol) and the returned value is of a different type.

 

You can either move the formula to a different column, or convert the result to the appropriate type.

 

Formula results may be converted to text values by adding an empty string. For example =TODAY() + "" will allow you to enter today's date into a text column.

 

What column type are you entering the formula into? That particular one needs to go into a text/number type column.