Count Unique Text Values with 2 criterias/condition

**Kim_18** · 01-21-2020, 10:52 PM

Hello everyone! I need some help on my excel spreadsheet. I tried to look for answers to resolve this for the past weeks but I got none that fits my current situation.

In Cell T12, I need to get a total unique text values from "POP-WS Registration column" cells B48-B300 based on these criterias: 1.) it should be tagged as "Closed" in topic status cells G48-G300; 2.) It should be categorize as "Workshop Process Improvement/ Wastes Reduction" in CI topic nature cell I48-I300.

Hope you could help me.

Thanks!

**FlameRetired** · 01-21-2020, 11:32 PM

Hello Kim_18. Welcome to the forum.

Try this formula.

Formula:

=SUMPRODUCT((($B$48:$B$300<>"")*($G$48:$G$300="Closed")*($I$48:$I$300="Workshop Process Improvement/ Wastes Reduction"))/COUNTIF($B$48:$B$300,$B$48:$B$300&""))

It returns 1 which is correct.

**Kim_18** · 01-28-2020, 01:35 AM

Thank You Dave, this formula works for me.

**AliGW** · 01-28-2020, 01:42 AM

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Count Unique Text Values with 2 criterias/condition

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Count Unique Text Values with 2 criterias/condition

Re: Count Unique Text Values with 2 criterias/condition

Re: Count Unique Text Values with 2 criterias/condition

Re: Count Unique Text Values with 2 criterias/condition

Thread Information

Users Browsing this Thread

Similar Threads

Count unique values in a table that meet one or two criterias

two condition before count unique text value.

Count Unique Values based on multiple criterias

Count Unique Values based on different Criterias

[SOLVED] Count unique values based multiple criterias

[SOLVED] How to count unique values using multiple criterias

Re: Count unique values from different columns with a condition

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions