Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-03-2011, 11:43 PM
PRADEEPB270's Avatar
PRADEEPB270 PRADEEPB270 is offline Construct a summary sheet by summing up from one or more than one sheet. Windows Vista Construct a summary sheet by summing up from one or more than one sheet. Office 2007
Novice
Construct a summary sheet by summing up from one or more than one sheet.
 
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, 12 views)
Reply With Quote
  #2  
Old 11-04-2011, 03:46 AM
macropod's Avatar
macropod macropod is offline Construct a summary sheet by summing up from one or more than one sheet. Windows 7 64bit Construct a summary sheet by summing up from one or more than one sheet. Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,506
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Hi Pradeep,

I don't think that's practicable with a formula. For example, for just one Plant in C4, for one month in C5 (which should be formatted as TEXT so that the input sheet name isn't converted to a date), the required formula for C15, which can be copied across & down to D22, is:
=SUMIFS(INDIRECT("'"&$C$5&"'!$R:$R",TRUE),INDIRECT ("'"&$C$5&"'!$Q:$Q"),$B15,INDIRECT("'"&$C$5&"'!$E: $E"),C$14,INDIRECT("'"&$C$5&"'!$B:$B"),$C$4)
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Construct a summary sheet by summing up from one or more than one sheet. change in the name of sheet accordingly Nirik Excel 3 11-02-2011 06:43 AM
Construct a summary sheet by summing up from one or more than one sheet. How do I specify which sheet to save as PDF? shabbaranks Excel Programming 3 09-14-2011 09:19 PM
Construct a summary sheet by summing up from one or more than one sheet. Insert Excel sheet markg2 Word 1 12-15-2010 12:19 PM
Construct a summary sheet by summing up from one or more than one sheet. Delete sheet through VBA Salim Khan Excel 1 08-30-2010 09:11 AM
copy cell from sheet 2 to sheet 3 macro slipperyjim Excel Programming 1 02-18-2010 01:31 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:24 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2022, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2022 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft