amp;"'!COST")))
Asa
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Haseeb A
Sent: Friday, May 11, 2012 11:52 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Re: Defining Same Name For ranges available in
multiple tabs
He
Hello Shekhar,
If I am following correctly, you can use SUMPRODUCT with SUMIF/INDIRECT
Enter the sheet names in D1:D10 (or how many you have. Do not include empty
cells in the range) of the summary sheet. then use
=SUMPRODUCT(SUMIF(INDIRECT("'"&$D$1:$D$10&"'!A:A"),A1,INDIRECT("'"&$D$1:$D$10&"'!
