Results 1 to 3 of 3

Counting Unique Values based on several criteria

Threaded View

  1. #1
    Registered User
    Join Date
    04-25-2012
    Location
    NZ
    MS-Off Ver
    Excel 2010
    Posts
    2

    Counting Unique Values based on several criteria

    Hi

    First post here.

    I'm working on a spreadsheet (Excel 2010) and I need to count the number of unique values in a column (K), where other values on the same row meet a set of criteria. I've managed to successfully SUM all the values in another column when they meet the criteria, but counting unique values is proving beyond me

    Here is my formula so far

    =COUNTIFS(LabourData!D:D,'Summary '!A$5,LabourData!O:O,H5,LabourData!J:J,CONCATENATE(">=",$B$2),LabourData!J:J,CONCATENATE("<=",$F$2),LabourData!G:G,"LAB")

    What I think this says is Count if;

    Column D = A$5 and
    Column O = H5 and
    The date in Column J is between the two dates specified in B2 and F2 and
    Column G = LAB

    How do I add the criteria that Column K should be unique?

    Thanks

    Adam
    Last edited by GowHow; 04-25-2012 at 08:34 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