Counting text in a column.
Hi Bob
Formula does not give correct results.
I was not clear and have given some data.
A B C
Boston Tasman Centenary
Wayback Boston Poole
I wish to count all text in column C that contain "Centenary" who have in
that row "Boston" in column A or "Boston" in column B.
Thanks for your help
CDP
--
CDP
"Bob Phillips" wrote:
=SUMPRODUCT(--(C2:C200100),SIGN((A2:A200="X")+(B2:B200="Y")))
--
---
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
"CDPalmer" wrote in message
...
I wish to count text in a column (say column C) such that (A or B) and C
are
satisfied.
Can someone help please.
Thanks
--
CDP
|