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