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 "A" has names of applicants wishing to work for me.

Column "B" has the recruitment company which sent them, some will have
multiple entries if they have forwarded many applicants, eg "Manpower".

Column "C" 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 "Manpowers"
applicants had a "y" response?

Any help would be very appreciated.