Help quick

[nempo]

Ok. I'm working with a customer who has two spreadsheets. She's tryin
to count the number of people based on there Lane and New Step.
She's has a section called Lane (which can be numbers from 1-6) and Ne
Step (which can be numbers from 1-19). Now the code is going to have t
check the selected cell's for the customer and then match them to th
other spreedsheet's correct lane and New step. So, when it's done
cant tell how many customer were a Lane #1 + New step #1 or Lane #1
New step #2. Does anyone have any idea's on how i would set this up.
though about IF statements, but i would need a for loop and i don'
think excel will enjoy my 3 page coding in Excel per Cell. Is there an
other way to do this

 

[Don Guillett]

have you tries using find and findnext

 

[nempo]

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

 

[Don Guillett]

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