+ Reply to Thread
Results 1 to 3 of 3

SUMIF - Based On Unique Values and Multiple Criteria

  1. #1
    Registered User
    Join Date
    04-04-2019
    Location
    England
    MS-Off Ver
    MS Office 2013
    Posts
    2

    SUMIF - Based On Unique Values and Multiple Criteria

    Good evening all,

    Attachment 618731
    I was wondering if someone would be kind enough to help me with the following please?


    What I am trying to achieve is the following:


    - Retrieve the gross balance for all accounts (excluding duplicates where there is >1 of the same entry / account) in Column A whilst also using Status – ‘’Open’’ (Column C) & Concept – ‘’000’’ (Column D) as ‘Criteria’ to drive the overall result returned in H2.


    - Retrieve the total number of accounts (excluding duplicates where there is >1 of the same entry / account) in Column A whilst also using Concept – ‘’000’’ (Column D) as ‘Criteria’ to drive the overall result returned in I2.


    - Retrieve the total number of accounts ‘’Off Sale’’ in Column E (excluding duplicates where there is >1 of the same entry / account in Column A) whilst also using Status – ‘’Open’’ (Column C) & Concept – ‘’000’’ (Column D) as ‘Criteria’ to drive the overall result returned in J2.
    I have been a regular viewer of these forums for year but I have seriously struggled with trying to achieve the above. I would be really grateful if someone with more excel knowledge and expertise could help?


    Many Thanks in advance!!!

  2. #2
    Registered User
    Join Date
    04-04-2019
    Location
    England
    MS-Off Ver
    MS Office 2013
    Posts
    2

    Re: SUMIF - Based On Unique Values and Multiple Criteria

    Picture of example data now attached

    Attachment 618734

  3. #3
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    Re: SUMIF - Based On Unique Values and Multiple Criteria

    Administrative Note:

    Welcome to the forum.

    We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

    Read this to understand why we (and other sites like us) consider this to be important.

    https://www.mrexcel.com/forum/excel-...-criteria.html

    (Note: this requirement is not optional. No help to be offered until the link is provided.)
    HTH
    Regards, Jeff

+ 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] Creating a list of unique values based on multiple criteria
    By 27POP27 in forum Excel General
    Replies: 5
    Last Post: 03-13-2019, 11:26 PM
  2. Getting unique values based on Multiple Criteria
    By gclode in forum Excel General
    Replies: 3
    Last Post: 06-20-2016, 02:19 PM
  3. [SOLVED] List unique values based on multiple criteria
    By tangmere.milli in forum Excel General
    Replies: 6
    Last Post: 01-22-2016, 07:56 AM
  4. Reading unique values based on multiple criteria
    By bscheideman in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-22-2015, 12:45 PM
  5. Count unique values based on multiple criteria
    By Jonathan11235 in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 05-19-2015, 10:02 PM
  6. [SOLVED] Counting Unique/Different Values based on multiple Criteria
    By jdodz in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-22-2014, 05:41 PM

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