This has speeded things up, Thankyou.

I created a column with the formula: =LEFT(D2,2). This created a list
of the products. Then i put in the formula in my "counting table"
=COUNTIF(L2:L6088,"01").

This has worked but when i fill down the count formula, the next line
becomes: =COUNTIF(L3:L6089,"01"). I want it to read
=COUNTIF(L2:L6088,"02").

In otherwords I just want the "criteria" to change. Do you know how to
do this?

Chris


--
cj21
------------------------------------------------------------------------
cj21's Profile: http://www.excelforum.com/member.php...o&userid=25673
View this thread: http://www.excelforum.com/showthread...hreadid=482177