Count?

[Guest]

I have a spreadSheet like the following:


A B C
D E

1 Customer ID Reference # Inv # Paid Inv. Date
No. of dist.
2 James Check #123 101 01/01/05
1
3 Mary Visa123 343
02/03/05 2
4 Mary Visa123 345 02/03/05
2
5 Buger /RR123 456 01/09/05
3
6 Buger /RR123 457 01/09/05
3
7 Buger /RR123 458 01/09/05
3


I need a formula or functions, or whatever that will count how many times a
check, visa or whatever ref # and put that count in the "No. of
Distributions" column. That same number has to be on each line assiocated
with that "reference #". I am sure there is a way. I tried the subtotal -
using the count but it doesnt total in the "no. of distrbutions column".

Need help AsaP!!!! Need answer 2nite - need to finished so I can sleep.
Been up since 12:45 a.m. Went to be at 10 p.m. Saturday nite.

PLease Please Help!!

 

[Guest]

Perhaps a pivot table will achieve it for you ..

 

[Guest]

That won't work. I need this to end up on a .CSV file to be imported into
another program. I re-posted with much neater version

 

[Guest]

First, thanks for replying. I'm out here, sorry.
Good luck with your fresh posting!

 

[Bob Phillips]

Just use

=COUNTIF(B:B,B2)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)