....missed last bracket ..

=SUMPRODUCT(--(A2:A5)=123456),--(b2:b5="SHIP"))

"Toppers" wrote:

=SUMPRODUCT(--(A2:A5)=123456),--(b2:b5="SHIP")

or

C1=123456 (set to number/text)
C2=SHIP

=SUMPRODUCT(--(A2:A5)=C1),--(B2:B5=C2)



"John Moore" wrote:

Hi guys, need a solution to a COUNTIF problem ,,, I want to be able to count
the number the number of times a number appears in a column based on the
criter of SHIP .... e.g.

A B
1 123456 SHIP
2 123456 NOT
3 123456 SHIP
4 343536 SHIP

so from the above table the result would be 2 for 1234546 SHIP.