if you have the checkmarks in say A2:A34
you can place the following formula in A35

A35: =COUNTIF(a$2:OFFSET(A35,-1,0),"a")

choice of checkmarks found in font tables
http://www.mvps.org/dmcritchie/rexx/...bols.htm#ticks
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Greegan" wrote in message ...
I have a field in my worksheet where I want a check mark to appear. I've
decided not to use the control boxes or whichever. I have used the letter
"a" in the Font of Marlett. This appears as the check mark on the screen.

I have copied the same sheet several times and I was given the formula
=SUM(ClientA:ClientB!A1) in a previous help request which seems okay.
I've been able to use that formula and used it as a COUNT for some other
information I needed.

The problem I'm having is that I cannot seem to count the number of checks
in B166.

I've tried in a cell where it just appears white on my screen so it doesn't
print out... =IF(B166="","",IF((B166="a"),"1",B166))
I've tried counting this cell and I've tried using SUM and nothing seems to
work.

Can someone please tell me what I'm doing wrong and how I can fix it?

Thank you in advance.

G