Thread: Formula to count entries as per month, year and submission wise from different sheets
View Single Post
 
Old 05-25-2013, 01:09 AM
pinkacidpunk pinkacidpunk is offline Windows XP Office 2007
Novice
  
Join Date: May 2013
Posts: 1
pinkacidpunk is on a distinguished road
Default Formula to count entries as per month, year and submission wise from different sheets
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,
Attached Files
File Type: xls Dashboard.xls (23.5 KB, 12 views)
Reply With Quote