Need some help finding a formula in excel..

[UHCoog]

Hello Everyone,

I'm looking for a formula that can give me count total of certain criteria. Here is my table. I want to get a total count of how many "EVERFLO" I have excluding duplicates in column 1. So the total I would get is 2 "EVERFLO"..


[TABLE="width: 269"]
<colgroup><col><col><col><col></colgroup><tbody>[TR]
[TD][TABLE="width: 284"]
<colgroup><col><col><col><col></colgroup><tbody>[TR]
[TD]column 1 [/TD]
[TD]column 2[/TD]
[TD]column 3 [/TD]
[TD]column 4[/TD]
[/TR]
[TR]
[TD]A502012DS[/TD]
[TD]5[/TD]
[TD]DVB[/TD]
[TD]515ADS[/TD]
[/TR]
[TR]
[TD]A548494DS[/TD]
[TD]5[/TD]
[TD]DVB[/TD]
[TD]515ADS[/TD]
[/TR]
[TR]
[TD]A548494DS[/TD]
[TD]5[/TD]
[TD]DVB[/TD]
[TD]515ADS[/TD]
[/TR]
[TR]
[TD]A554781DS[/TD]
[TD]5[/TD]
[TD]DVB[/TD]
[TD]515ADS[/TD]
[/TR]
[TR]
[TD]H55667DS[/TD]
[TD]5[/TD]
[TD]DVB[/TD]
[TD]515ADS[/TD]
[/TR]
[TR]
[TD]0011644[/TD]
[TD]5[/TD]
[TD]RESP[/TD]
[TD]ULTRA FILL[/TD]
[/TR]
[TR]
[TD]0063461[/TD]
[TD]5[/TD]
[TD]RESP[/TD]
[TD]EVERFLO[/TD]
[/TR]
[TR]
[TD]0063461[/TD]
[TD]5[/TD]
[TD]RESP[/TD]
[TD]EVERFLO[/TD]
[/TR]
[TR]
[TD]0064296[/TD]
[TD]5[/TD]
[TD]RESP[/TD]
[TD]EVERFLO[/TD]
[/TR]
[TR]
[TD]0064296[/TD]
[TD]5[/TD]
[TD]RESP[/TD]
[TD]EVERFLO[/TD]
[/TR]
[TR]
[TD]0064296[/TD]
[TD]5[/TD]
[TD]RESP[/TD]
[TD]EVERFLO[/TD]
[/TR]
[TR]
[TD]0064296[/TD]
[TD]5[/TD]
[TD]RESP[/TD]
[TD]EVERFLO[/TD]
[/TR]
[TR]
[TD]0064296[/TD]
[TD]5[/TD]
[TD]RESP[/TD]
[TD]EVERFLO[/TD]
[/TR]
[TR]
[TD]0064296[/TD]
[TD]5[/TD]
[TD]RESP[/TD]
[TD]EVERFLO[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


Thank You

 

[Aladin Akyurek]

Control+shift+enter, not just enter:

=SUM(IF(FREQUENCY(IF($A$2:$A$15<>"",IF($C$2:$C$15="EVERFLO",
  MATCH($A$2:$A$15,$A$2:$A$15,0))),ROW($A$2:$A$15)-ROW($A$2)+1),1))

 

[UHCoog]

Thank You! It worked perfectly!

 

[Aladin Akyurek]

Thank You! It worked perfectly!

You are welcome. Thanks for providing feedback.

 

[Jborg]

Aladin has my great respect. He is a master in formulae and I learn alot from him, but allow my version with a slight difference.
=SUM(--(FREQUENCY(IF($B$3:$B$16<>"",IF($E$3:$E$16=$K$3,MATCH($B$3:$B$16,$B$3:$B$16,0))),ROW($C$3:$C$16)-ROW($C$3)+1)>0))