If you ONLY allow the cell to be either the check character or
blank,
you could test for the blank COUNT and subtract from the total check
box
COUNT. The answer would yield the number of checked boxes.

So, you count the blanks instead.

In this case I'd probably count the checks so I don't have to include
the extra math calcs.<g

=COUNTA(#:#)

... # is the row[s] to evaluate.

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion