Results 1 to 6 of 6

Sumproduct with Multiple (Header) Criteria - Sumproduct, Index, Match

Threaded View

  1. #1
    Valued Forum Contributor
    Join Date
    04-13-2011
    Location
    Ottawa, Canada
    MS-Off Ver
    365
    Posts
    1,101

    Sumproduct with Multiple (Header) Criteria - Sumproduct, Index, Match

    Hello Excel Gurus,

    I have a simple question for you (hard for me). I believe it involves sumproduct, index and match. Of course, if there's a simpler way, would be better.

    The problem is this. I have a list of countries (going down the rows) with it's respective gross revenue and net revenues for each month (across the column).

    I'm trying to find the sum of each country in each month for each revenue.

    I have attached an excel file for a clear picture of how the data was set up and what are my desired results to be.

    I googled sumproduct, and came up with this (see below - this is only for country Asia for Net Revenue in Jan 2011). However, this is "manually" looking at the headers. Therefore, I'm wondering if there's a way to make it "auto" to be able to smart enough to look at the headers (revenue and its month) and sum it up through formulas (which I believe it can be done)



    =SUMPRODUCT(--($A$3:$A$11=$A21), D$3:D$11)
    Attached Files Attached Files
    Last edited by dluhut; 04-19-2012 at 12:45 PM.

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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