Count # of times a Reference is used

[Guest]

I have a spreadsheet like the following:


A B C D E

1 CustID Ref # 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 associated
with that "reference #". I am sure there is a way. I tried the subtotal -
using the count but it doesn’t total in the "no. of distributions 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 night.

Please Please Help!!

 

[Guest]

I almost forgot this file will end up as a .csv to be imported into another
program.

 

[Biff]

Hi!

Looks like this should work:

=COUNTIF(B$2:B$7,B2)

Copy down as needed. Adjust references to suit.

Biff

 

[Peo Sjoblom]

=COUNTIF($B$2:$B$100,,B2)

copy down

replace the range with your range and B2 with the first cell you want to
count


--


Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com

 

[Peo Sjoblom]

Oops! I managed to get an extra comma in there somehow, should be one comma


--


Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com

 

[Guest]

Thank you SO VERY MUCH!!!!! YOU ARE A GENIIUSA!!!!!