+ Reply to Thread
Results 1 to 3 of 3

Counting Unique Values based on several criteria

  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.

  2. #2
    Forum Contributor Russell Dawson's Avatar
    Join Date
    03-01-2012
    Location
    Yorkshire, England
    MS-Off Ver
    2007
    Posts
    604

    Re: Counting Unique Values based on several criteria

    Hi Adam,

    Welcome to the forum. Please upload an example of your workbook. Check out the Forum Rules.

    Regards

    Russell
    If I helped, please don't forget to add to my reputation. (click on the star below the post)

    If the problem is solved, please: Select Thread Tools (on top of your 1st post) -> Mark this thread as Solved.

    Failure is not falling down but refusing to get up.

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

    Re: Counting Unique Values based on several criteria

    Ok, I've managed to strip any sensitive infor out of the file

    The formula I need help with is in 'WeeklyReport!' Column E

    I'm trying to count how many unique entries there are in 'LabourData!'ColumnO, where 'LabourData!'G:G = LAB;'LabourData!'D:D = "'Summary'!$B$1";'LabourData!'O:O = 'WeeklyReport'!H5 (or I5,J5,etc); 'LabourData!'J:J is between 'WeeklyReport'! date range - i.e. $B$2 and $F$2

    Does this help?
    Attached Files Attached Files

+ 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