# COUNTIF Formula

#### Beachson

##### Active Member
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.

### Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.

#### ParamRay

##### Well-known Member
.
.

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

=COUNTIF(A:A,A1)

Thanks very much

Replies
2
Views
170
Replies
0
Views
357
Replies
2
Views
294
Replies
2
Views
233
Replies
1
Views
375

1,191,117
Messages
5,984,747
Members
439,907
Latest member
Kayfabe

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back