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



"Peo Sjoblom" wrote in message
...
=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



"klafert" wrote in message
...
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
btotal -
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!!