On 2 Aug, 16:22, J. G. Skains <J. G.
wrote:
I have an inventory spreadsheet, the first worksheet keeps a count of what we
have and what has been sent out. What I need to do is count the number of
items of a specific product that has been sent out, based on the date it was
sent. Furthermore, because new information is regularly added, I need to
count from the entire range of column.

Example:

Column A = Date sent, Column B = Product Model

A B
7/12/2007 T60
7/12/2007 T60
7/20/2007 X60
7/20/2007 T60
Blank T60
Blank X60
Blank T60
7/13/2007 X60

From this example I need to count on a different sheet the number of T60's
that have been sent without counting the X60's or the models that have not
been sent out (i.e. Blank).

sumproduct could be used to do this (see a large number of postings on
the subject in this area) BUT you might like to look at a pivot table
which would give you a very quick summary of ALL conditions.