Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting text in two columns
I have two columns
A = words such as supporter, staff, board B = regsitered, not registered etc I want to count number with two pieces if info - i.e number of staff that have registered; number of supporters that are not registered Help! i have excel 2003 Thanks, |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting text in two columns
Hi,
Try this. =sumproduct((rangeA="Supporter")*(rangeB="Register ed")) -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Lisa" wrote in message ... I have two columns A = words such as supporter, staff, board B = regsitered, not registered etc I want to count number with two pieces if info - i.e number of staff that have registered; number of supporters that are not registered Help! i have excel 2003 Thanks, |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting text in two columns
Awesome - THanks! i was trying to do it where "supporter" was referred to as
a cell number (A263), which wasn't working - you presumably have to enter the actual text. "Ashish Mathur" wrote: Hi, Try this. =sumproduct((rangeA="Supporter")*(rangeB="Register ed")) -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Lisa" wrote in message ... I have two columns A = words such as supporter, staff, board B = regsitered, not registered etc I want to count number with two pieces if info - i.e number of staff that have registered; number of supporters that are not registered Help! i have excel 2003 Thanks, |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting text in two columns
Hi,
For technical reasons the following is a useful alternative: =SUMPRODUCT(--(A$1:A$100=C1),--(B$1:B$100=D1)) First the references to C1 and D1 allow greater flexability, you might also consider range names for A1:A100 and B1:B100, and the -- avoids some problems when using * might cause a problem depending on data types, such as errors. -- Thanks, Shane Devenshire "Lisa" wrote: I have two columns A = words such as supporter, staff, board B = regsitered, not registered etc I want to count number with two pieces if info - i.e number of staff that have registered; number of supporters that are not registered Help! i have excel 2003 Thanks, |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting text in two columns
Thank you for the feedback.
-- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Lisa" wrote in message ... Awesome - THanks! i was trying to do it where "supporter" was referred to as a cell number (A263), which wasn't working - you presumably have to enter the actual text. "Ashish Mathur" wrote: Hi, Try this. =sumproduct((rangeA="Supporter")*(rangeB="Register ed")) -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Lisa" wrote in message ... I have two columns A = words such as supporter, staff, board B = regsitered, not registered etc I want to count number with two pieces if info - i.e number of staff that have registered; number of supporters that are not registered Help! i have excel 2003 Thanks, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting a series of text and/or numbers within columns | Excel Discussion (Misc queries) | |||
counting text across multiple columns | Excel Worksheet Functions | |||
Counting a mixed text/number column based on text in another colum | Excel Discussion (Misc queries) | |||
Counting Occurrence of Text within Text in Cells in Range. | Excel Worksheet Functions | |||
counting columns | Excel Worksheet Functions |