Formula to count entries

Hi Everyone,

I am new to this forum. Hope some one can help me out with my query.

I have a table as follow and need to count the entries automatically based on monthly

Column A Column B Column C Column D
Detailed Plan 05-Jan-2013 10-Jan-2013 +4
Detailed Plan & Estidama 05-Jan-2013 15-Jan-2013 -1
Detailed Plan 02-Feb-2013 20-Feb-2013 -9
Detailed Plan 02-Feb-2013 12-Feb-2013 -1
Detailed Plan & Estidama 09-Mar-2013 18-Mar-2013 0

Column A represents the document, Column B the document submitted date, Column C review completion date and column D measure the review time against 10 days KPI, it is within service level or not.

I need a formula to calculate the number of document submitted in jan , feb and march which is within KPI and without KPI.

Could someone help me out here?

Thanks,

i have attached the file and on sheet two is what the answer should look like. (i have considered -1 within KPI. i mean >=-1 are within KPI and <=-1 are all out of KPI.) I hope you understand my query.

Thank a ton sixth sense.

what of column b had another entry Detailed Design? would it count?

what if i add a new entry in the future in column B and the name would be Detailed Design not detailed plan or detailed plan & estidama?

Using Sixthsenses' formulae in B9:B10 from Post #4
You might consider this in B11

Formula:

Please Login or Register  to view this content.

in that case i have another question. Hope you dont mind. i have attached the scenario. this time it should count only the Detailed Plan and Detailed Plan & Estidama for Column B excluding the other entries. Is it Possible?

Is this for total submissions?

what about Out of KPI and WIthin KPI?

Thank you Sixthsense and Marcol. Much appreciated.