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,
|