Count Unique Values Based On Two Criteria - how do I update this formula?

**JuNova** · 04-29-2018, 08:51 PM

Hello,

I have a formula that counts unique values based on one criteria, but I need to update it to count unique values based on two criteria. Please help!
Attached is the example: In column H I have applied formula to count uniq number of bottles, but now want to add one ore criteria which is now many used unique bottles there are. How do I amend current formula to give me the outcome like in column F?

Many thanks!
J.

**Phuocam** · 04-29-2018, 11:22 PM

Try this:

=SUM(IF(($A$2:$A$8=E4)*($C$2:$C$8="Yes"),1/COUNTIFS($A$2:$A$8,$A$2:$A$8&"",$B$2:$B$8,$B$2:$B$8&"",$C$2:$C$8,"Yes")))

Array formula, enter with Ctrl+Shift+Enter.

**JuNova** · 04-30-2018, 03:27 AM

It worked! Thank you

))

Count Unique Values Based On Two Criteria - how do I update this formula?

LinkBack

Thread Tools

Rate This Thread

Display

Count Unique Values Based On Two Criteria - how do I update this formula?

Re: Count Unique Values Based On Two Criteria - how do I update this formula?

Re: Count Unique Values Based On Two Criteria - how do I update this formula?

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Count unique (text) values based on two criteria

[SOLVED] Count Unique Values based on 2 criteria

count unique values based on between dates with a criteria

Using sum if frequency to count unique values based on certain criteria

[SOLVED] Count unique values based on criteria but without array formula (CSE)

Count unique values based on several criteria

how to count unique values in excel based on criteria

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions