I would like to count all fields which contain the
symbol checkmark.
In another instance I am using the formula
=COUNTIF(B124:B137,"X") to count all fields
which contain an X.
However I don't know the reference for the
symbol checkmark.
Thanks.
I would like to count all fields which contain the
symbol checkmark.
In another instance I am using the formula
=COUNTIF(B124:B137,"X") to count all fields
which contain an X.
However I don't know the reference for the
symbol checkmark.
Thanks.
What font are you using for the checkmark?
If Wingdings, =COUNTIF(rng, CHAR(252))
Last edited by shg; 10-19-2008 at 01:15 PM.
Entia non sunt multiplicanda sine necessitate
I am using Windings Bold....is that
a different reference for bold because
the formula you provided gives me a
#NAME? error.
Thanks.
Replace rng with your actual range: =COUNTIF(B124:B137, CHAR(252))
Thanks for your help.
It works like a charm.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks