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

Reply via email to