Prev: How do I page break in the middle of a row in Excel?
Next: Doing a countif against a substring of the range to be scanned
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.
 | 
Pages: 1
Prev: How do I page break in the middle of a row in Excel?
Next: Doing a countif against a substring of the range to be scanned