try this. Does NOT need array entering.

=sumproduct((rngA="id1220")*(rngB="gray"))

--
Don Guillett
SalesAid Software

"Robert Dieckmann" wrote in message
...
Thanks to those who responded to my previous post. On the same
spreadsheet (Excel 2000) I have these values in columns A & B

ID1220 - gray
ID1220 - white
ID1624 - gray
ID1220 - white
ID1624 - white
ID1220 - red

Here I am trying to find out how many units I have of the various colors
of a particular size. What I want to know is:
ID1220 - gray = 1
ID1220 - white = 2
ID1220 - red = 1

Again, I am assuming this has to be done in an array but I know very
little about them.
Thanks in advance.

Robert