Counting Wingdings

I am using arrow wingdings (CHAR233 or CHAR234) in the same
column and I would like to count them.

I don't need a separate count of 233s or 234s I just need a
count if the column is occupied by one or the other.

I have tried various contexts of the formula posted below without
success.

How do I count multiple characters in the same cell?

Thanks.

=COUNTIF(A11,CHAR(233,CHAR(234))

I must not have stated my question correctly.

The contents of A11 could be CHAR233 or CHAR234
and I need to count the contents as 1 whichever character
it contains.

When I used =LEN(A11) - LEN(SUBSTITUTE(A11, CHAR(234), ""))
the contents of A11 was one CHAR233 and the answer it gave
me was 0 and it should been one.

Thanks.

Try these:

=COUNTIF(A11,"*"&CHAR(233)&"*")
=COUNTIF(A11,"*"&CHAR(234)&"*")

Or

=COUNTIF(A11;"*"&CHAR(233)&"*")+COUNTIF(A11,"*"&CHAR(234)&"*")

.

Thanks for helping. The last two formulas work if I'm counting single cells, however,
in most instances I am counting a range.

For example, I have tried adjusting the formulas below to include A40:A51 and
I get a wrong answer.

COUNTIF(A11;"*"&CHAR(233)&"*")+COUNTIF(A11,"*"&CHAR(234)&"*")

=2 * LEN(A11) - SUM(LEN(SUBSTITUTE(A11, {"é","ê"}, "") ) )

I finally figured it out.

=COUNTIF(B40:B51,"*"&CHAR(233)&"*")+COUNTIF(B40:B51,"*"&CHAR(234)&"*")

Thanks for pointing me in the right direction.

Originally Posted by scotfitz

Thanks for helping. The last two formulas work if I'm counting single cells, however,
in most instances I am counting a range.

For example, I have tried adjusting the formulas below to include A40:A51 and
I get a wrong answer.

COUNTIF(A11;"*"&CHAR(233)&"*")+COUNTIF(A11,"*"&CHAR(234)&"*")

=2 * LEN(A11) - SUM(LEN(SUBSTITUTE(A11, {"é","ê"}, "") ) )

Your question is not clear.

Can you attach sample file and please give your result.

.