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

pinkacidpunk · #1 05-25-2013, 01:09 AM

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,

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
sumproduct formula to pull info from multiple sheets	Berk21	Excel	7	01-15-2012 11:41 AM
How to count year lapse (rounded off) based on specific date	KIM SOLIS	Excel	1	11-01-2011 10:50 AM
Formula to calculate Leap Year	USAOz	Excel	2	09-11-2011 04:58 PM
Count If Formula	beb1227	Excel	10	06-19-2011 11:19 AM
Auto insert current month's name and current year	Styler001	Word	4	01-25-2010 06:40 PM