how do I count checkmarks in excel?

  • Thread starter Thread starter Jack Weinstein
  • Start date Start date
J

Jack Weinstein

I am doing an attendance sheet to record college students'
acivities (I am a college professor). I have been entering
numeric values, one for present, two for absent. But I
want to just use checkmarks. The problem is, I don't know
how to add up the number of checks. How do I insert a
check box in a particular cell (with a series of twenty-
thirty checkmarks in a row)? I think I have that figured
out, but I may be doing it incorreclty. Then hoow do I
have, listed, in the last cell of the row, how many checks
are in the boxes?
 
Jack, insted of check boxs how about this, you could format your cells as
Marlett then type the letter a, this will put a check mark in the cell and
then just count the number of a's like this =COUNTIF(A1:A10,"a"). you could
also use a macro that would put the check mark in the cell when you click in
it
--
Paul B
Always backup your data before trying something new
Using Excel 2000 & 97
Please post any response to the newsgroups so others can benefit from it
** remove news from my email address to reply by email **
 
If you want to make it a point and click feature without
using a macro, you could use a data validation drop down
list with the tick (checkmark).

Biff
 
Back
Top