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,

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,

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,

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,

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,