How to count unique status on daily basis for each HR expert

Urgent Help needed

--------------------------------------------------------------------------------

Hi

I need a formula/procedure to calculate which expert has interviewed how many candidate
on daily bases along with the count of their status like on hold,rejected,shortlisted.

There is one consolidated sheet for all experts I want to pick data from that sheet to fill the below mention sheet on daily basis.

please help me asap!!!

vibhor_sharma100@yahoo.co.in



Expert Monday-16 may -11
Status Line Up Shortlisted On Hold Rejected Offered
Sam
Rakhi
Vibhor
Ram
prem




Main sheet tabs:

Date of Interview Current Status Recruiters's Name Day week

You will have better luck if you posted an example workbook. It sounds like a simple COUNTIFS formula would return the results you need.