COUNTIF Formula

[Beachson]

If I have a column of order numbers (column A) and a column of product items (column B) and I want to know how many product items each order has how would I do that? I prefer not to use a pivot table for this. Technically I just want to know how many times the same order number appears in column A.

 

[ParamRay]

.
.

Put this formula in cell C1 and autofill to the last row of data:

=COUNTIF(A:A,A1)

 

[Beachson]

Thanks very much