Fwd: $$Excel-Macros$$ Sumproduct accross multiple sheets

2012-03-02 Thread Sundarvelan N
Friends help me on this help. Thanks N.Sundarvelan 9600160150 -- Forwarded message -- From: Sundarvelan N nsund...@gmail.com Date: Fri, Mar 2, 2012 at 11:52 AM Subject: $$Excel-Macros$$ Sumproduct accross multiple sheets To: excel-macros@googlegroups.com Hi Friends, Help me

Re: $$Excel-Macros$$ Sumproduct accross multiple sheets

2012-03-02 Thread Haseeb Avarakkan
Hi, Assume the sheet name always be in dd-mmm-yy format. I have define a name CurrPeriod, you need to define it on your file. Just change Start End Date reference in this formula. I also change some Locations for SALES in multiple sheets to make sure it works :-) See the attached.

$$Excel-Macros$$ Sumproduct accross multiple sheets

2012-03-01 Thread Sundarvelan N
Hi Friends, Help me in achieving this task. sumproduct across multiple sheets Thanks N.Sundarvelan 9600160150 -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code