software

Hello
I was hoping someone could help me with a problem i have. I am trying to
count a response (Y/N) in a range with the condition that they are from a
particular type in another range.

Eg.
Column quot;Aquot; has names of applicants wishing to work for me.

Column quot;Bquot; has the recruitment company which sent them, some will have
multiple entries if they have forwarded many applicants, eg quot;Manpowerquot;.

Column quot;Cquot; has a Yes/No response based on whether they were successful.

What i would like to do is creat a count of the number of successful
applicants from a recruitment company. So, count how many of quot;Manpowersquot;
applicants had a quot;yquot; response?

Any help would be very appreciated.
=SUMPRODUCT(--(B2:B50=quot;Manpowerquot;),--(C2:C50=quot;Yesquot;))

or better

=SUMPRODUCT(--(B2:B50=G1),--(C2:C50=H1))

where you would put the temp/recruitment agency in G1 and the Yes/No in H1

another way would be to use the autofilter (datagt;filtergt;autofilter)
then filter on company and Yes, then use

=SUBTOTAL(3,B2:B50)--
Regards,

Peo Sjoblom

Northwest Excel Solutions

Portland, Oregon

quot;J-Razquot; gt; wrote in message
news
gt; Hello
gt; I was hoping someone could help me with a problem i have. I am trying to
gt; count a response (Y/N) in a range with the condition that they are from a
gt; particular type in another range.
gt;
gt; Eg.
gt; Column quot;Aquot; has names of applicants wishing to work for me.
gt;
gt; Column quot;Bquot; has the recruitment company which sent them, some will have
gt; multiple entries if they have forwarded many applicants, eg quot;Manpowerquot;.
gt;
gt; Column quot;Cquot; has a Yes/No response based on whether they were successful.
gt;
gt; What i would like to do is creat a count of the number of successful
gt; applicants from a recruitment company. So, count how many of quot;Manpowersquot;
gt; applicants had a quot;yquot; response?
gt;
gt; Any help would be very appreciated.
gt;
gt;On Sat, 11 Feb 2006 18:16:27 -0800, quot;J-Razquot; gt;
wrote:

gt;Hello
gt;I was hoping someone could help me with a problem i have. I am trying to
gt;count a response (Y/N) in a range with the condition that they are from a
gt;particular type in another range.
gt;
gt;Eg.
gt;Column quot;Aquot; has names of applicants wishing to work for me.
gt;
gt;Column quot;Bquot; has the recruitment company which sent them, some will have
gt;multiple entries if they have forwarded many applicants, eg quot;Manpowerquot;.
gt;
gt;Column quot;Cquot; has a Yes/No response based on whether they were successful.
gt;
gt;What i would like to do is creat a count of the number of successful
gt;applicants from a recruitment company. So, count how many of quot;Manpowersquot;
gt;applicants had a quot;yquot; response?
gt;
gt;Any help would be very appreciated.
gt;

You could use a pivot table.

Drag quot;Companyquot; to the Rows Area
Drag quot;Responsequot; to the Columns Area
Drag quot;Namesquot; to the Data area. (Make sure it does quot;Countquot; of Names)

Apply any of a variety of formats to the result
--ron