Results 1 to 6 of 6

Sumif Unique

Threaded View

  1. #1
    Registered User
    Join Date
    11-04-2010
    Location
    Canada
    MS-Off Ver
    Excel 2003
    Posts
    11

    Sumif Unique

    I am having a bit of trouble with trying to sum only unique values of an array.

    1-1 8.00000
    1-2 14.00000
    1-3 19.00000
    2-1 2.00000
    2-1 2.00000

    Since 1-1, 1-2 and 1-3 are all unique. I want to add that into the total along with ONE of 2-1.
    The total should be 43.

    I am able to do sumif and frequency for specific lines, but I have a big list and will be constantly changing..
    Much appreciated if anyone can help me out.
    Attached Files Attached Files
    Last edited by bushmills; 03-23-2011 at 05:45 PM.

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