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