ExcelBanter - Countif

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Countif (https://www.excelbanter.com/excel-discussion-misc-queries/217424-countif.html)

Linexe

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

Mike H

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

All times are GMT +1. The time now is 03:43 AM.