SUMIF with NAME RANGE
 

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.

SUMIF with NAME RANGE
 

http://www.microsoft.com/office/comm...8-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.