From: Big_Tater on 29 Mar 2010 13:07 I'm really struggling with this and I know someone here can help with this formula. I'm not sure what I'm missing. I have 2 worksheets ('Monthly Report'! and 'Summary by Month'!). Both sheets have column \$B6:\$B137 with Company IDs. I have sales numbers in 2 columns on "Summary by Month'! for each month (D6:E135) which are named with a Range Name for each month. (ie. SUM_JAN = D6:E137, SUM_FEB = H6:I137, etc.) I have a drop down list on the 'Monthly Report'! sheet in cell D5 so any agent can select the month they wish to see sales revenue for all Companies. I know I'm missing something simple, but I have been working on this for 2-days now. Here is what I have: =IF('Summary by Month'!B6:B137,B6,SUM_FEB),INDIRECT(D5) I posted this yesterday, but I can't find the post so I don't think I posted it right. Sorry if this is a duplicate. Any help is REALLY appreciated. From: Gary''s Student on 29 Mar 2010 13:24 http://www.microsoft.com/office/community/en-us/default.mspx?&query=Big_Tater&lang=en&cr=US&guid=&sloc=en-us&dg=microsoft.public.excel.misc&p=1&tid=85b28da6-6c88-41f4-aef8-5afa0aeb0eed -- Gary''s Student - gsnu201001 "Big_Tater" wrote: > I'm really struggling with this and I know someone here can help with this > formula. I'm not sure what I'm missing. > > I have 2 worksheets ('Monthly Report'! and 'Summary by Month'!). Both sheets > have column \$B6:\$B137 with Company IDs. I have sales numbers in 2 columns on > "Summary by Month'! for each month (D6:E135) which are named with a Range > Name for each month. (ie. SUM_JAN = D6:E137, SUM_FEB = H6:I137, etc.) > > I have a drop down list on the 'Monthly Report'! sheet in cell D5 so any > agent can select the month they wish to see sales revenue for all Companies. > I know I'm missing something simple, but I have been working on this for > 2-days now. > > Here is what I have: > =IF('Summary by Month'!B6:B137,B6,SUM_FEB),INDIRECT(D5) > > I posted this yesterday, but I can't find the post so I don't think I posted > it right. Sorry if this is a duplicate. > > Any help is REALLY appreciated.