There you go
=SUM(INDIRECT("'2011 Actual'!$C$3:"&ADDRESS(3,MATCH("*"&TEXT('Monthly
IS'!$J$3,"MM/YY")&"*",'2011 Actual'!$A$1:$N$1,0))))
On Aug 26, 2:28 am, Steve Weaver <steveweave...@comcast.net> wrote:
> Thank you Sam for this suggestion. However, the formula doesn't provide
> the results that I am looking for.
>
> The formula shown below gives me the results only for the month of July.
> I am looking for the YTD results (Nov thru July). The result should be
> 11,862,396.
>
> Any further suggestions?
>
> Thank you!
>
> Steve
>
> ------------------------------------------------------------------------
>
> On 8/24/2011 2:37 PM, Sam Mathai Chacko wrote:
>
>
>
> > =INDIRECT("'2011 Actual'!"&ADDRESS(3,MATCH("*"&TEXT('Monthly
> > IS'!$J$3,"MM/YY")&"*",'2011 Actual'!$A$1:$N$1,0)))
>
> > On Wed, Aug 24, 2011 at 7:37 PM, Steve Weaver
> > <steveweave...@comcast.net <mailto:steveweave...@comcast.net>> wrote:
>
> > Does anyone have either an idea or suggestion?
>
> > Thanks!
>
> > Steve
>
> > On 8/22/2011 7:00 PM, Steve Weaver wrote:
> >> I should have been a little more perceptive and realized that I'd
> >> have a slightly difference issue with YTD results.
>
> >> Is there someway to modify the formula in cell D9 (modified
> >> formula to be used in cell N9) so that it would return the sum of
> >> the months beginning with November thru the month shown in cell J3?
>
> >> Thank you for your help!
>
> >> Steve
>
> >>
> >> ------------------------------------------------------------------------
>
> >> On 8/20/2011 1:05 AM, GoldenLance wrote:
> >>> Use =INDIRECT("'2011
> >>> Forecast'!"&ADDRESS(28,MATCH(TEXT(J3,"MMMM"),'2011 Forecast'!$A$2:$X
> >>> $2,0))) in Monthly IS, range F9
>
> >>> Steve, sure you can replicate this for all your cells.
>
> >>> Regards,
>
> >>> Sam Mathai Chacko (GL)
>
> >>> On Aug 19, 9:53 pm, Steve Weaver<steveweave...@comcast.net>
> >>> <mailto:steveweave...@comcast.net> wrote:
> >>>> Hi,
>
> >>>> Can some one help me to create a formula in excel. Using the attached
> >>>> file, please refer to the "Monthly IS" tab, column D. I need help
> >>>> writing a formula that will:
>
> >>>> 1. retrieve the appropriate value from the "2011 Actual" tab based
> >>>> on
> >>>> the month shown in "Monthly IS" tab, cell J3.
> >>>> 2. retrieve the appropriate value from the "2011 Forecast" tab
> >>>> based on
> >>>> the month shown in "Monthly IS" tab, cell J3.
>
> >>>> Thank you for your help.
>
> >>>> Steve
>
> >>>> IS Example.XLS
> >>>> 640KViewDownload
>
> >> --
> >>
> >> ----------------------------------------------------------------------------------
> >> Some important links for excel users:
> >> 1. Follow us on TWITTER for tips tricks and links :
> >> http://twitter.com/exceldailytip
> >> 2. Join our LinkedIN group @
> >> http://www.linkedin.com/groups?gid=1871310
> >> 3. Excel tutorials athttp://www.excel-macros.blogspot.com
> >> <http://www.excel-macros.blogspot.com/>
> >> 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
> >> <http://www.quickvba.blogspot.com/>
> >> 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com
> >> <http://exceldailytip.blogspot.com/>
>
> >> To post to this group, send email to
> >> excel-macros@googlegroups.com <mailto:excel-macros@googlegroups.com>
>
> >> <><><><><><><><><><><><><><><><><><><><><><>
> >> Like our page on facebook , Just follow below link
> >> http://www.facebook.com/discussexcel
>
> > --
> >
> > ----------------------------------------------------------------------------------
> > Some important links for excel users:
> > 1. Follow us on TWITTER for tips tricks and links :
> > http://twitter.com/exceldailytip
> > 2. Join our LinkedIN group @
> > http://www.linkedin.com/groups?gid=1871310
> > 3. Excel tutorials athttp://www.excel-macros.blogspot.com
> > <http://www.excel-macros.blogspot.com/>
> > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
> > <http://www.quickvba.blogspot.com/>
> > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com
> > <http://exceldailytip.blogspot.com/>
>
> > To post to this group, send email to excel-macros@googlegroups.com
> > <mailto:excel-macros@googlegroups.com>
>
> > <><><><><><><><><><><><><><><><><><><><><><>
> > Like our page on facebook , Just follow below link
> > http://www.facebook.com/discussexcel
>
> > --
> > Sam Mathai Chacko
> > --
> > ----------------------------------------------------------------------------------
> > Some important links for excel users:
> > 1. Follow us on TWITTER for tips tricks and links :
> >http://twitter.com/exceldailytip
> > 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310
> > 3. Excel tutorials athttp://www.excel-macros.blogspot.com
> > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
> > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com
>
> > To post to this group, send email to excel-macros@googlegroups.com
>
> > <><><><><><><><><><><><><><><><><><><><><><>
> > Like our page on facebook , Just follow below link
> >http://www.facebook.com/discussexcel
>
>
>
> IS Example.XLS
> 650KViewDownload- Hide quoted text -
>
> - Show quoted text -
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
