1. =SUMPRODUCT((A1:A100="X")*(B1:B100={"X","(X)"}))
2. =COUNTIF(A:A,"X~*")
--
HTH
Bob Phillips
(replace somewhere in email address with gmail if mailing direct)
"Magic Speller"
wrote in message
news:Magic.Speller.2bkqx6_1153953909.4467@excelfor um-nospam.com...
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