# Counting Unique Values based on several criteria

1. ## 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

Regards

Russell

3. ## 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?

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### 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