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?