Hi

One way
Use a helper column with the formula, say in C1
=--(AND(B1="jpr",COUNTIF($A$1:A1,A1)=1))
copy down as far as required
=SUM(C:C)
--
Regards

Roger Govier


wrote in message
oups.com...
New to excel formulas and need help with a problem.

example:

A B
3324 jpr
2756 jpr
3324 jpr
2856 slt
3492 slt
5864 bdg
2856 slt
2756 jpr

I am trying to get a count of the jpr's in col B , that have a
different number in col A.
the solution in this example should be 2 for jpr.