formula to count how many times a word appears in a row for a date

Dear all,

I'm breaking my head how to do this. I have a sheet with in column A a range with different words. In column B there are dates. So if a team member has a partialy rejected case, he will fill it in column A and put a date in column B and in column C the case number. Now I need to count how many partially rejected cases where that day and that number goes later in a month report. I was hoping to do this with a If formula or a sumif formula. I just don't find information how to deal with this kind of case.

The workbook we have is as per month, so every month we produce a new month and fill it again. Every team member has his own sheet where he fills it in for the whole month.

If any one could help, would be great.

Thanks in advance.
megatronixs

pls upload a sample so that we can help you..

Hello Fotis,

Thank you for your email. Please find attached the workbook as example.
Please let me know if you need more info.

Greetings
megatronixs

Hello Fotis,

It works like magic ;-)
Thanks a lot for your help.

greetings,
megatronixs