Countif
Maybe
=SUMIF(A:A,C1,B:B)
With your lookup value in C1
Mike
"Linexe" wrote:
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
|