View Single Post
 
Old 11-03-2011, 11:43 PM
PRADEEPB270's Avatar
PRADEEPB270 PRADEEPB270 is offline Windows Vista Office 2007
Novice
 
Join Date: Aug 2011
Location: Gurgaon-INDIA
Posts: 17
PRADEEPB270 is on a distinguished road
Default Construct a summary sheet by summing up from one or more than one sheet.

I have a file,contains 12 sheets ( Month wise ) and each sheet have approx. 400000 rows.Now,I want to make a summary sheets by given some input datas and expect the required datas from the sheets.
For an example,if ,I want to give the input as plant-HHHD and Month-Oct,2011,then, represent the Oct'2011 datas and plant HHHD only.Sometimes,it is to be happen,that, plant may be HHHD and HHHG and month may be Oct,Nov and Dec.In that case, the summary sheet should be shown as the sum of both of plants and also the sum of months.
Is it possible through an excel formula?

For more clarification,please refer the attached file.
(Pl.to be note that each sheet of attached file size has reduced )


If it is possible,put the excel formula on attached file.

Regards

Pradeep Kumar Gupta
Attached Files
File Type: zip New Folder.zip (168.0 KB, 16 views)
Reply With Quote