+ Reply to Thread
Results 1 to 4 of 4

Sum problem with multiple criteria - Sumifs with a dynamic sum range for columns

  1. #1
    Forum Contributor
    Join Date
    01-11-2013
    Location
    Sweden
    MS-Off Ver
    MS 365
    Posts
    188

    Sum problem with multiple criteria - Sumifs with a dynamic sum range for columns

    Hi,

    Im having trouble with a huge spreadsheet. It's a little bit hard to explain so i have uploaded a sample workbook. But i will try to explain.

    You could say that i need help with a sumifs, where i want the sum range to be dynamic so it changes when a certain criteria is met. Depending on whats in a cell i need to change which column to sum from. The value in the cell is the same as one of the headers for the columns.

    In the uploaded workbook there are two sheets. One named "Report" and one named "Data". In the report sheet i need to calulate based on row values (depending on whats in a cell here) from different columns and rows in the Data sheet. I am pretty sure you will understand if you take a look at the uploaded workbook.

    Really hoping for some assitance here although i realize i expressed myself poorly.

    /Masun
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    09-20-2011
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    2,278

    Re: Sum problem with multiple criteria - Sumifs with a dynamic sum range for columns

    Hello Masun

    Does the following SUMPRODUCT function do as you require:

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    This is in C3 copied across and down to F14.

    DBY

  3. #3
    Forum Contributor
    Join Date
    12-17-2013
    Location
    ON, Canada
    MS-Off Ver
    MS 365
    Posts
    119

    Re: Sum problem with multiple criteria - Sumifs with a dynamic sum range for columns

    Hi Masun,

    Another approach might be to convert your data to a table and use a Pivot Table.

    SumWithMultipleCriteria.xlsx

  4. #4
    Forum Contributor
    Join Date
    01-11-2013
    Location
    Sweden
    MS-Off Ver
    MS 365
    Posts
    188

    Re: Sum problem with multiple criteria - Sumifs with a dynamic sum range for columns

    DBY, Thank you!! I am struggling a bit with the sumproduct, i dont find it intuitive at all. I have some work to do there. Once again thanks for the help!! Flyboy, thanks for making an effort in helping me out.

    /Masun

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Dynamic sumifs in a table with multiple criteria
    By JEAN1972 in forum Excel General
    Replies: 5
    Last Post: 12-04-2015, 07:25 PM
  2. [SOLVED] SUMIFS with a dynamic, offset criteria range
    By adelcap in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-22-2014, 05:35 AM
  3. Replies: 5
    Last Post: 06-06-2013, 05:12 PM
  4. problem with sumifs with multiple criteria
    By usmc0331 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 05-18-2013, 01:46 PM
  5. [SOLVED] sumifs function to calculate dynamic range sum problem
    By xs2deepak in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 01-25-2013, 04:24 PM
  6. Replies: 3
    Last Post: 11-21-2012, 04:57 PM
  7. Replies: 1
    Last Post: 05-16-2011, 05:00 PM

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