Formula to count entries as per month, year and submission wise from different sheets

[pinkacidpunk]

Hi Everyone,

Could anyone help me with generating a formula to calculate the total submissions?



I have the excel sheet attached and the answers on the sheet 2.

Could some one help me with generating formula for first two table?

Total submission=Detailed Plan + Detailed Plan & Estidama (from sheet CS-CP) + Site Mobilization (from Sheet Mobilization) + DOT (from Sheet DOT) submitted for the year 2013 and month Jan, FEb and March

Thanks,

[BobBridges]

I think we're going to be able to help, pink, but I at least am gonna need more information. Here are my guesses so far:

1) In your attached document, the first three sheets (CS-CP, Mobilization and DOT) contain the raw data; Sheet2 is where you want the results. In Sheet2, the tables on the left show the correct figures but you worked them manually; the tables on the right are eventually to hold formulae for calculating the same figures.

2) Each formula in Sheet2 should spot the relevant rows in one or more of the first three worksheets, and display either the number of rows or the sum of the KPI column—I can't tell which.

3) I THINK the relevant rows are the ones whose document name matches one of the strings provided, eg "DOT" or "Detailed Plan & Estidama".

So I take it you want each formula to select a) one or more of the other worksheets, and in each one select the rows b) whose Document Name matches one of the desired strings and c) whose month falls in the desired range, and finally d) to display some sum regarding those rows. Am I on the right track, or did I misunderstand even that?