Thanks guys, it got resolved with the suggestion of
=SUMIF(sheet1!WBS,A1,sheet1!COST)+SUMIF(sheet2!WBS,A1,sheet2!COST)+SUMIF(sheet3!WBS,A1,sheet3!COST)
** **
On Sat, May 12, 2012 at 6:48 PM, dguillett1 dguille...@gmail.com wrote:
This is very possible with an indirect formula or
Not the BEST solution.
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Shekhar Sharma
Sent: Monday, May 14, 2012 7:16 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Defining Same Name For ranges available in
multiple tabs
Thanks guys, it got
]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Shekhar Sharma
Sent: 14 May 2012 5:46
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Defining Same Name For ranges available in
multiple tabs
Thanks guys, it got resolved
[mailto:
excel-macros@googlegroups.com] *On Behalf Of *Shekhar Sharma
*Sent:* 14 May 2012 5:46
*To:* excel-macros@googlegroups.com
*Subject:* Re: $$Excel-Macros$$ Defining Same Name For ranges available
in multiple tabs
** **
Thanks guys, it got resolved with the suggestion of
=SUMIF
This is very possible with an indirect formula or defined names or with a
macro. Provide a file and your desires.
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Shekhar Sharma
Sent: Friday, May 11, 2012 4:59 AM
To: excel-macros@googlegroups.com
Subject:
: 11 May 2012 3:45
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Defining Same Name For ranges available in
multiple tabs
Dear Shekhar,
Please share your workbook with group, It is possible through Indirect
Function.
--
Thanks regards,
Noorain Ansari
www.noorainansari.com
Hi Shekhar,
You can use:
=SUMIF(sheet1!WBS,A1,sheet1!COST)+SUMIF(sheet2!WBS,A1,sheet2!COST)+SUMIF(she
et3!WBS,A1,sheet3!COST)
Or, if the ranges are identical on each sheet, you can use 3-D references
with certain functions (but not with SUMIF) to refer to basically a union
of the identical
-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Asa Rossoff
Sent: Friday, May 11, 2012 8:18 PM
To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ Defining Same Name For ranges available in
multiple tabs
Hi Shekhar,
You can use:
=SUMIF(sheet1!WBS,A1,sheet1