Hi, everyone.

I have two questions:

1. Can anyone tell me what formula I can use to count the number of
rows with an "X" in column A and either an "X" or an "(X)" in column
B?

In other words, when applied to:

A B
1 X
2 X X
3 X (X)
4 X
5 X X

it should give me 3.

2. Is there a way to get the '*' character recognized as a character,
and not a wildcard, in a formula? I want to use something like:

COUNTA(A10:A200, "X*")

but if I do it this way, of course, it will count "X*", "XX", and
"X***".

Thanks for your help!


--
Magic Speller
------------------------------------------------------------------------
Magic Speller's Profile: http://www.excelforum.com/member.php...o&userid=36830
View this thread: http://www.excelforum.com/showthread...hreadid=565406