Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I enter formula sum(range+range)*0.15 sumif(range=3) | Excel Discussion (Misc queries) | |||
SumIf - when I fill down the Range, Criteria & sum range changes | Excel Worksheet Functions | |||
SUMIF sum range | Excel Worksheet Functions | |||
Sumif between a range | Excel Discussion (Misc queries) | |||
SUMIF - Range name to used for the "sum_range" portion of a SUMIF function | Excel Worksheet Functions |