Thread: Countif
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Linexe Linexe is offline
external usenet poster
 
Posts: 14
Default Countif

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