+ Reply to Thread
Results 1 to 6 of 6

Sum values in column based on variable values in 3 other columns

  1. #1
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Exclamation Sum values in column based on variable values in 3 other columns

    Hi all,

    I don't know if this can be done with DSUM or SUMPRODUCT or whatever. The attached WB shows what I have on Sheet1, with what I need to accomplish on Sheet2.

    Any help will be much appreciated
    Attached Files Attached Files

  2. #2
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Sum values in column based on variable values in 3 other columns

    Hi Winon,

    See the attached file and let me know if this helps in solving your purpose. thanks.
    Columns Data Sample.xlsx

    Regards,
    DILIPandey

    <click on below 'star' if this helps>
    DILIPandey, Excel rMVP
    +919810929744 (India), +971528225509 (Dubai), [email protected]

  3. #3
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: Sum values in column based on variable values in 3 other columns

    Hello dilipandey,

    Thank you for your help!

    Are you a Magician? The Totals per Colour Column seems to check out o.k., but not the Sub-Totals.

    I have changed the formulas in F6 to G7, to give you an idea. The thing now is to find the right formula to get the correct Sub-Total.

    That is what I am having an issue with.

    Thank you
    Attached Files Attached Files

  4. #4
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Sum values in column based on variable values in 3 other columns

    I am not a Magician
    Just a Excel lover ..

    would suggest you to sort your data.. first on column Product Range and then on color and let me know if this works .. thanks.


    Regards,
    DILIPandey

    <click on below 'star' if this helps>

  5. #5
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: Sum values in column based on variable values in 3 other columns

    Hi DILIPandey,

    Unfortunately It is important to keep the four columns of Data in Line With the Job No., Product Range, Color and Qty. Sorting only one or two of tose columns will distort the Data integrity.

  6. #6
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Sum values in column based on variable values in 3 other columns

    Hi Winon,


    After Sorting and applying formula, you can copy paste the results and then you can re-sort your data as per the Data Integrity ..

    Regards,
    DILIPandey

    <click on below 'star' if this helps>

+ Reply to Thread

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