Counting text in a column.

[CDPalmer]

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

 

[Mike H]

Perhaps some sample data would clarify what you mean

 

[Bob Phillips]

=SUMPRODUCT(--(C2:C200>100),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]

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

 

[Bob Phillips]

=SUMPRODUCT(--(C2:C200="Centenary"),SIGN((A2:A200="Boston")+(B2:B200="Boston")))

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[CDPalmer]

Hi Bob

Worked beautifully.

Thanks very much.

CDP