Results 1 to 6 of 6

SUMIF with INDIRECT

Threaded View

  1. #1
    Registered User
    Join Date
    03-29-2010
    Location
    Kyle, Texas
    MS-Off Ver
    Excel 2010
    Posts
    33

    SUMIF with INDIRECT

    Hey all, I'm new here and have searched many forums for my answer but can't find one. Like this forum the best so registered and plan to stay.

    Here's my problem:

    I have 2 worksheets/tabs ('Monthly Report'! and 'Summary by Month'!) in my Workbook. Both sheets have column $B6:$B137 with Company IDs. I have sales revenue in 2 columns on "Summary by Month'! for each month 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 any company. I know I'm missing something simple, but I have been working on this for 2-days now.

    Here is what I have, but it only gives me the revenue for column D not column E in my Range Name:
    =SUMIF('Summary by Month'!$B$6:$B137,$B6,INDIRECT($D$5))

    Again, D5 is where I have my Range Names in a drop down so the agents can see any month revenue by company.

    Any help is REALLY appreciated. I'm going blind trying to figure this out.
    Last edited by Big_Tater; 03-30-2010 at 11:33 AM. Reason: SOLVED

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1