Thread: [Solved] Construct a summary sheet by summing up from one or more than one sheet.
View Single Post
 
Old 11-04-2011, 03:46 AM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,962
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