>
> *Rajan verma*
>
> *+91 7838100659 [IM-Gtalk]*
>
> ** **
>
> *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-Mac
[IM-Gtalk]
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 with
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
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 wrote:
> This is very possible with an indirect formula or defined names or with
> a
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: $$Excel-
a
From: excel-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(
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
ps.com]
On Behalf Of NOORAIN ANSARI
Sent: 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.
-
Dear Shekhar,
Please share your workbook with group, It is possible through Indirect
Function.
--
Thanks & regards,
Noorain Ansari
www.noorainansari.com
www.excelmacroworld.blogspot.com
On Fri, May 11, 2012 at 3:29 PM, Shekhar Sharma wrote:
> I'm wondering if it's possible to define one name
