Counting text in a column.

C

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
 
B

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)
 
C

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
 
B

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Counting text in a column 8
Excel Pivot Table - Counting Unique Values within one column of da 1
SUMIFS, one criteria range, multiple criteria 3
How can I calculate the numbers? 2
lookup vaules which are not exist in a table 3
How to count responses? Possibly use COUNTIF? 4
Count If Column A = x and Column B = y 18
Adding numbers to text! 4

Top