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