# Countifs for unique entries

#### shawnhet

##### Well-known Member
Hi guys,

I am having an issue that seems like it should be simple but I am not able to get correct answers from the options I have tried.

I currently have the following expression that I am trying to alter so it counts only unique items:

=COUNTIFS(Memblist!\$AH:\$AH,"*"&\$A4&"*",Memblist!\$K:\$K,"Active",Memblist!\$B:\$B,"Volunteer")

Currently this counts all active volunteers who are registered in a particular group and I would like it to count all unique active volunteers (uniqueness determined by member number somewhere in Memblist!C:C).

In other words, each Active member per group is only counted once, no matter how many times his/her number shows up in that group.

I am probably missing something simple so hopefully someone can point me in the right direction.

Cheers,

### Excel Facts

Excel Joke
Why can't spreadsheets drive cars? They crash too often!
Hi guys,

I am having an issue that seems like it should be simple but I am not able to get correct answers from the options I have tried.

I currently have the following expression that I am trying to alter so it counts only unique items:

=COUNTIFS(Memblist!\$AH:\$AH,"*"&\$A4&"*",Memblist!\$K:\$K,"Active",Memblist!\$B:\$B,"Volunteer")

Currently this counts all active volunteers who are registered in a particular group and I would like it to count all unique active volunteers (uniqueness determined by member number somewhere in Memblist!C:C).

In other words, each Active member per group is only counted once, no matter how many times his/her number shows up in that group.

I am probably missing something simple so hopefully someone can point me in the right direction.

Cheers,

Control+shift+enter, not just enter:
Rich (BB code):
``````=SUM(IF(FREQUENCY(IF(Memblist!\$C\$2:\$C\$100<>"",
IF(ISNUMBER(SEARCH(\$A4,Memblist!\$AH\$2:\$AH\$100)),
IF(Memblist!\$K\$2:\$K\$100="Active",IF(Memblist!\$B\$2:\$B\$100="Volunteer",
MATCH("~"&Memblist!\$C\$2:\$C\$100,Memblist!\$C\$2:\$C\$100&"",0))))),
ROW(Memblist!\$C\$2:\$C\$100)-ROW(Memblist!\$C\$2)+1),1))
``````

Last edited:

Have an awesome day!

Have an awesome day!

You are welcome. Thanks for providing feedback.

Replies
11
Views
137
Replies
3
Views
153
Replies
12
Views
561
Replies
3
Views
463
Replies
2
Views
313

1,196,130
Messages
6,013,624
Members
441,777
Latest member

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back