then perhaps a sumproduct formula will help???
=sumproduct((a2:a22="lane #1")*(b2:b22="step $19"))

--
Don Guillett
SalesAid Software

"nempo" wrote in
message ...

I have though of that. However, the problem is is if those two Cell's
don't match the other two. Then i need it to continue going down until
it finds the right one. My main question i guess is can you use for
loops and hold varibles. Because pretty much i need to create something
that will Say this spreedsheet is Lane #1 and New Step #1 if customer is
this then add one if not go to New Step #2. If get's to Step #19 Then
start over and go to Step #1 until you find the correct location to add
one. So, once it's all done ill be able to tell how many customer are
Lane #4 and Have New Step #2. (There's 156 Customers).


--
nempo
------------------------------------------------------------------------
nempo's Profile:
http://www.excelforum.com/member.php...o&userid=28401
View this thread: http://www.excelforum.com/showthread...hreadid=563474