Counting from one range to another range, multiple criteria

Giganews Newsgroups
Subject: Counting from one range to another range, multiple criteria
Posted by:  macamarr
Date: Fri, 9 Jun 2006

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.

Replies