Advanced techniques

[Kyle]

I created an Excel workbook containing several worksheets
to help me track the recruiting efforts of my company.
The first worksheet contains the day to day activity of
our recruiters (new candidates, initial interviews, job
offers, etc). The source of the candidate is listed on
this first page (e.g. college recruit, referral, web
recruiting, etc) as well. A seperate worksheet in the
same workbook contains a breakdown of the sources...how
many candidates came from each source, how many initial
interviews came from each source, how many offers were
made for each source of recruiting, etc. Is there anyway
to have the second worksheet automatically populated by
completing the first worksheet? This question probably
makes no sense without seeing the actual spreadsheets. I
am happy to email them to anyone willing to help me.
I've been pulling my hair out over this one. Thanks!

 

[Guest]

Hi,

I hope this solves your problem. There is a function in
Excel COUNTIF, which can be used to solve the problem.
Let me try to understand the problem and then the
solution.

For example your sheet is as follows.

A B
Name Source
Xyz Web
Pqr Referral

And so on.

Go to the sheet where you have to find the summary.
Select the cell where you have to find the result and
enter this function if you have to find the recruitments
from Web.

=COUNTIF(B:B,"Web")

In the above formulae, you can also give a cell reference
instead of manually writing "Web".

I hope the above solves your problem.

Regards.