Thread
:
Help quick
View Single Post
#
4
Posted to microsoft.public.excel.worksheet.functions
Don Guillett
external usenet poster
Posts: 10,124
Help quick
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
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett