# Counting Unique Values with one criteria between a given date range?

1. ## Counting Unique Values with one criteria between a given date range?

So this is my first post on this forum, mostly because I have spent months lurking and pulling code from other posts. (That's how it should be done on a forum, right ) But I have finally gotten to a problem I haven't been able to solve myself.

This is another unique frequency question also with two conditions. However the difference with my situation is that mine seems to combine two of the common problems, both of which I have solved independently, but have not been able to make work in conjunction.

I need to count unique entries in a list of numbers that fall between a given date range, with one criteria. I have mocked up a sample of my data to explain.  Register To Reply

2. ## Re: Counting Unique Values with one criteria between a given date range?

Hello,

Assume users always be a valid numbers. If so try these Array Formulas, If users are not valid numbers will need to use MATCH.

I2,

=SUM(SIGN(FREQUENCY(IF(Table1[Criteria]="N",Table1[User]),Table1[User])))

I3,

=SUM(SIGN(FREQUENCY(IF(Table1[Date]>=K3,IF(Table1[Date]<=L3,Table1[User])),Table1[User])))

I6,

=SUM(SIGN(FREQUENCY(IF(Table1[Date]>=K3,IF(Table1[Date]<=L3,IF(Table1[Criteria]="N",Table1[User]))),Table1[User])))  Register To Reply

3. ## Re: Counting Unique Values with one criteria between a given date range?

Oh that is elegant! Thanks for the quick reply!

=SUM(SIGN(FREQUENCY(IF(Table1[Criteria]="N",Table1[User]),Table1[User])))

This is beautiful...basically reduces it to a sumifs function! This would have saved me a week of searching. Thanks again.  Register To Reply

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