count # of orders in a range

[avandever]

i want to count how many times the order shows up in the entire column. so for example, for the "A243381" order, column B for each one of the lines it would say 5 since there are 5 of them in this list. thanks.


sonum
261370
A242860-1
A243118R
A243379
A243380
A243381
A243381
A243381
A243381
A243381
A243382
A243382
A243382
A243382
A243382

 

[asad]

How about this:

Excel Workbook
	A	B
1	sonum
2	261370	1
3	A242860-1	1
4	A243118R	1
5	A243379	1
6	A243380	1
7	A243381	5
8	A243381	5
9	A243381	5
10	A243381	5
11	A243381	5
12	A243382	5
13	A243382	5
14	A243382	5
15	A243382	5
16	A243382	5
Sheet1

 

[avandever]

ugh, i'm an idiot. i had the exact same thing but kept putting =A7 instead of just A7. thanks!

 

[avandever]

to expand off this one i am looking to count if the date is equal or less than X date.

right now i have:

=COUNTIF(Master!$AS$5:$AS$21967,Report!D5)

but i want it to be less than or equal to Report!D5 and just adding <=Report!D5 did not work. thanks.

 

[T. Valko]

to expand off this one i am looking to count if the date is equal or less than X date.

right now i have:

=COUNTIF(Master!$AS$5:$AS$21967,Report!D5)

but i want it to be less than or equal to Report!D5 and just adding <=Report!D5 did not work. thanks.

Try it like this...

=COUNTIF(Master!$AS$5:$AS$21967,"<="&Report!D5)