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,