# Need some help finding a formula in excel..

#### UHCoog

##### New Member
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"..

 column 1 column 2 column 3 column 4 A502012DS 5 DVB 515ADS A548494DS 5 DVB 515ADS A548494DS 5 DVB 515ADS A554781DS 5 DVB 515ADS H55667DS 5 DVB 515ADS 0011644 5 RESP ULTRA FILL 0063461 5 RESP EVERFLO 0063461 5 RESP EVERFLO 0064296 5 RESP EVERFLO 0064296 5 RESP EVERFLO 0064296 5 RESP EVERFLO 0064296 5 RESP EVERFLO 0064296 5 RESP EVERFLO 0064296 5 RESP EVERFLO

<colgroup><col><col><col><col></colgroup><tbody>
</tbody>

<colgroup><col><col><col><col></colgroup><tbody>
</tbody>

Thank You

### Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a \$25,000 loan, 5% annual interest, 60 month loan.
Control+shift+enter, not just enter:
Rich (BB code):
``````=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))
``````

Thank You! It worked perfectly!

Thank You! It worked perfectly!

You are welcome. Thanks for providing feedback.

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

Replies
5
Views
405
Replies
3
Views
550
Replies
1
Views
247
Replies
1
Views
858
Replies
2
Views
228

1,196,512
Messages
6,015,629
Members
441,912
Latest member
Rayna_rahman00

### 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