Is it not just =COUNTIF(B:B,"<")

--
HTH

Bob Phillips

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

"macamarr" wrote in message
...
I have 600 account # and 5 five weeks of deliveries. All the account
numbers
are in column A and all the account # delivered are in column B. What I
need
to do is count all the accounts delivered and place the count in column C.
If
there is a way please inform. Thank You!


I am trying to avoid having to type/change the criteria in each lines
formula.