Totalling the number of check marks in my check list
I know this question has been answered but the formula given did not work for me. I have a checklist with column A being where my check marks are. I would like to add the check marks from A2:A42. the formula I used was
=COUNTIF(A2:A42, TRUE) and the answer I got was 0 which is not right, cause I at least have 28 check marks on that list.
Help!!!