# How do you count unique values using criteria?

@cram88Example:How many unique distinct products did Jennifer sell in January?Array formula in C3:=SUM(IF(("Jennifer"=\$D\$6:\$D\$27)*(\$B\$6:\$B\$27&lt;=DATE(2011, 1, 31)), 1/COUNTIFS(\$D\$

@cram88

Example:

How many unique distinct products did Jennifer sell in January?

Array formula in C3:

=SUM(IF(("Jennifer"=\$D\$6:\$D\$27)*(\$B\$6:\$B\$27<=DATE(2011, 1, 31)), 1/COUNTIFS(\$D\$6:\$D\$27, "Jennifer", \$E\$6:\$E\$27, \$E\$6:\$E\$27, \$B\$6:\$B\$27, "<="&DATE(2011, 1, 31))), 0))

Count unique distinct values that meet multiple criteria

*Any articles, templates, third-party products or information I have provided are for reference only. While I endeavor to keep the information up to date and correct as far as I can. I make no representations or warranties, express or implied, as to the completeness, correctness, reliability, suitability, or availability of any product or information, article, file, template, or related graphic on my posts in this forum. The trust you place in such information is therefore entirely at your own risk.

I would be happy to know if I could help.

Nikolino

I know I don't know anything (Socrates)

* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.