Countifs for unique entries

[shawnhet]

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,

 

[Aladin Akyurek]

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:

=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))

 

[shawnhet]

Terrific!! Thanks Aladin!

Have an awesome day!

 

[Aladin Akyurek]

Terrific!! Thanks Aladin!

Have an awesome day!

You are welcome. Thanks for providing feedback.