+ Reply to Thread
Results 1 to 4 of 4

sum up the unique column values according the condition operator with other cells

  1. #1
    Registered User
    Join Date
    04-24-2015
    Location
    101
    MS-Off Ver
    2007
    Posts
    50

    sum up the unique column values according the condition operator with other cells

    hi,

    i have a sheet having car number (D column),year of purchase (E column), accumulated at end of year (I column) and total cost (Q column)..

    my problem is for example the car number 12 ...

    i need to get the value in one cell like this ....

    sum up the I column according to year ,car number and the sum up value should be less than total cost(Q column). if it is greater than total cost then need to keep total value....

    problem is the cell range or cell address don't know. they are generated.

    how to do that.... can any one help me please


    New Microsoft Office Excel Worksheet.xlsx

  2. #2
    Registered User
    Join Date
    08-18-2015
    Location
    Utrecht, Netherlands
    MS-Off Ver
    2010
    Posts
    69

    Re: sum up the unique column values according the condition operator with other cells

    Hi,

    with "need to keep total value" you mean the total value of the sum of column I?

    Reagrds

  3. #3
    Forum Expert skywriter's Avatar
    Join Date
    06-09-2014
    Location
    USA
    MS-Off Ver
    365 Version 2409
    Posts
    2,789

    Re: sum up the unique column values according the condition operator with other cells

    You could try this formula. D24 is one of your cells with 12 in it. You could put 12 directly into the formula instead of D24 or you could reference another cell where you type in the car number of your choice.

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

  4. #4
    Registered User
    Join Date
    08-18-2015
    Location
    Utrecht, Netherlands
    MS-Off Ver
    2010
    Posts
    69

    Re: sum up the unique column values according the condition operator with other cells

    Hi,

    Maybe this function I made for you can help you:

    Please Login or Register  to view this content.
    Copy this to a module in VBA and you can use it the same way you use regular formulas. It needs carnumber, year, SearchRange (1st column of range should contain carnumber, 2nd column year and 3rd column accumulated) and totalCosts.

    Regards,

    Bart

+ 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. Replies: 2
    Last Post: 08-19-2015, 10:22 AM
  2. [SOLVED] Average unique values with condition
    By emortals in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-21-2015, 07:51 AM
  3. [SOLVED] Count Unique Values in a Range with Condition
    By vij8y in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 01-28-2015, 05:45 AM
  4. Counting unique values based on condition in a different column
    By rafuk73 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-21-2014, 02:59 PM
  5. [SOLVED] Looking up unique values from a column of identical cells
    By Groovicles in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 11-14-2013, 10:35 AM
  6. Replies: 4
    Last Post: 07-16-2013, 09:45 AM
  7. Count Unique Values In One Column Basis Unique Values in Another Column
    By shez_raz in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 04-07-2012, 01:55 AM

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