Creating a count when the information from two cells is true.

J

J. G. Skains

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).
 
A

aidan.heritage

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).
Click to expand...

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.
 
J

J. G. Skains

Thanks for the info. the pivot table works to an extent but it won't let me
control how things are named and or laid out. I will do a little more
research on the sumproduct function and see if I can get it to do what I want.
 
Top