how to count the total of a checkbox field?

Megha Natani

I need to count the total no. of check marked cells in a column

Stephan Hertig

=COUNTIF(Done:Done, 1)

Change "Done" to ur desired colum name

Megha Natani

thanks. also, I need to count all the values in a column except 1. how do I go about that?

Jeff Reisman

Do you mean you need to count all values except for where the value = 1? Are you trying to add all the values together? Or trying to just count how many cells in that column contain a value other than "1"?

Jeff Reisman

To count the number of cells containing a value greater than 1:

=COUNTIF([ColumnName]:[ColumnName], >1)

To add together all values greater than 1:

=SUMIF([ColumnName]:[ColumnName], >1)