Counting text in a column.
 

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

Counting text in a column.
 

Perhaps some sample data would clarify what you mean

"CDPalmer" wrote:

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

Counting text in a column.
 

=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

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

Counting text in a column.
 

=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" wrote in message
...
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

Counting text in a column.
 

Hi Bob

Worked beautifully.

Thanks very much.

CDP
--
CDP


"Bob Phillips" wrote:

=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" wrote in message
...
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