| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting a mixed text/number column based on text in another colum | Excel Discussion (Misc queries) | |||
| Counting text in a column | Excel Discussion (Misc queries) | |||
| counting text in a column | New Users to Excel | |||
| COUNTING TEXT CELLS IN A COLUMN | Excel Worksheet Functions | |||
| Counting NUMBERS &/or TEXT from a column to other sheet ? | Excel Worksheet Functions | |||
Linear Mode
