Countif

[Linexe]

Can someone help me on a countif problem.

I have a list of parts with Qty, but not all in the same order.

I want to be able to count the Qty colum (B) IF the part number
matches (A)

A B C

1112 2
1111 1
1234 4
1112 1
1234 3


I have come up with the formula of =COUNTIF(A2:A67,A2), but this only
counts the amount of part number rather than the qty

Would be grateful for any ideas

Linexe

 

[Mike H]

Maybe

=SUMIF(A:A,C1,B:B)

With your lookup value in C1

Mike