formulas for counting the analyst work during a day

Dear all,

I have a sheet that has 1 sheet for the data and 1 sheet for the monitoring of the total work done.
In the monitoring sheet there are 2 parts. First part is where you see the total for that day and the second part you see it split per analyst.
The analyst will register a case, put their name in column B and date in column C. This will be counted in the Reg in sheet "Monitoring" in Cell H (for the given analyst) taken in account the date in cell E2.
When an analyst starts the case, he will put his name in column D an date in column E. This will be counted in the sheet "Monitoring" i taken in account E2.
If an analyst finish the case with all information, then he can pass it to a second person thas has a second check (QA) only when the case is ready for second check it can be filled in column F and this will appear in column J in sheet "Monitoring" for the given analyst. When one of the analyst does a second check for another analyst, then he puts his name in column H and date in column I from the Sheet1. This will be counted in column K in sheet "Monitoring" for the given analyst. When the analyst sends the case out, then he should put the date in column i and date in column J from the sheet1. This should then be counted in the column L from sheet "monitoring" for the given analyst taken in account always the date from E2 in the sheet "Monitoring"

Then we come to the part that counts the totals for all cases done that day.
We will see how many cases where registered that day (found in the same sheet in E2. And so goes for started, for QA, for QA done and sent.

I really hope some one can help out. I heard that it can be done with formulas, but have no clue where to start as the formula should look for date, analyst name and amount at the same time and that is way to complicated for what I know of formulas.

Please see the attached excel 2003 file.

If it is not very clear, please let me know.

Thanks in advance.

Greetings
Megatronixs

Hello Benishiryo,

Thank you for your help on this. I rather stick to the formulas as they kind of make things easier for me. I tried to understand the formulas and made some changes that make more sense to me. I will try later on to write the question with more logic and with some explanations in the sheet it self to explain with more detail. I also will add both, the data and the monitoring to only 1 sheet so it is more clear in how they should interact.

Greetings and thanks again for your help and I hope with more clear explanation this will be working easier :-)

Megatronixs

Dear all,
As last time it was not that logical what I wanted to do, I will just post
here the one that is the dificult one.
I have a list where team members fill in while producing some documents.
What I need to do is counting how many where passed for a second check. I need
to count per person. So if Peter started a document and finish it and pass it
for second check he fills in the start date in column B and his name in column
C. When he pass it on, he fills in the date in column D. The number of documents
should appear in C22 (B22 is the name of the person)
As in the case in the attached excel file, you see that on 26/11/2012 he passed
2 documents for second check. Karl did 2 on 15/11/2012 and 1 in 16/11/2012 and John
did pass 2 on the 20/11/2012.
In the calendar control I used VBA so when you select a date, it will show it
in cell C2. The formula should take this date to check how many for that day
where passed for second check.

Can some one help with the formulas as I have no idea how to do this. The condition
should be that the Date start producing is filled in, the analyst producing and
the Date passed for 2nd check.

Any help would be really appriciated.

Greetings,
Megatronixs