Count unique cells with multiple conditions

**Sladamuss** · 03-13-2016, 05:10 AM

Hi all,

I have been trying to build a formula in MS Excel 13 without using VB or a macro.
I want to count the number of times each Service Name (column B) is displayed, that has a Unique number in column C, has data in column D and has either a 1,2 or 2M in Column A

is this possible?

Count unique cells with multiple conditions-4.xlsx

**Tony Valko** · 03-13-2016, 05:19 AM

This array formula** entered in H2 and copied down:

=SUM(IF(FREQUENCY(IF(B$2:B$16=F2,IF(D$2:D$16<>"",IF(ISNUMBER(MATCH(A$2:A$16,{1,2,"2M"},0)),C$2:C$16))),C$2:C$16)>0,1))

** array formulas need to be entered using the key
combination of CTRL,SHIFT,ENTER (not just ENTER).
Hold down both the CTRL key and the SHIFT key
then hit ENTER.

**Sladamuss** · 03-13-2016, 06:52 AM

Hi Tony,

thank you, that worked perfectly!

**Tony Valko** · 03-13-2016, 07:59 AM

You're welcome. Thanks for the feedback!

Count unique cells with multiple conditions

LinkBack

Thread Tools

Rate This Thread

Display

Count unique cells with multiple conditions

Re: Count unique cells with multiple conditions

Re: Count unique cells with multiple conditions

Re: Count unique cells with multiple conditions

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Count unique cells based on multiple conditions

[SOLVED] Count unique cells based on multiple conditions

Count Unique Item #'s with multiple conditions

Count unique values with multiple conditions

Count unique logs with multiple conditions of multiple sheets

Advanced unique cell count with multiple conditions ... help!

Count Unique text based on multiple conditions

Bookmarks

Bookmarks

Posting Permissions