SUMIF with NAME RANGE

B

Big_Tater

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SUMIF with NAME RANGE 1
Linking to other worksheets 3
Referencing a named range on another sheet 4
summaries on alternative sheets 6
Creating external references to spreadsheets with changing names 1
Use Sum() with variable range 4
SumIF 3
#Ref on Sumproduct 0

Top