I understand what you are saying, but only partially. I do not see how
that would work, though I may be missing it.

What I need the formula to do is look at the cells preceeding it in the
row, and based on a list of job codes determine what job codes are
listed in that row, then determine what value is assigned to them, and
add those values.

I believe that I have roughly worked out the logic to do this which I
will attempt to write out in english here.

#1: I want the cell (let's say cell A4) to "think": "Is there a job
code in cell A1 that is found in the job code list? Yes, it is "Bar".
Ok then, what is the number associated with that job code? It is 8.
Store the number 8. Now, is there a job code in cell A2 that is found
in the list? No. Is there a job code in cell A3 that is found in the
list? Yes, it is "Section A." What is the number associated with that
job code? It is 6. Store the number 6. Any more cells? No. Now what is
the sum of all the numbers that I have found. It is 14. I display the
number 14. "

So basically this is the "does the value in Cell "whatever" match a
value in a certain list, and if so, what is the number associated with
that value" method.

This may not be the only logic to determine this information, but
basically the formula needs to evaluate each cell that preceeds it,
determine if the value in each cell matches a value in a list, and then
assign a number to those values that match, and add the numbers then
display the sum.

I understand that I will have to make two lists: the first is a job
code list, and directly next to it will be a list of numbers associated
with each code, so that if in cell A20 I have "bar," then in cell B20 I
have "8." And if in cell A21 I have "Section A," then in cell B21 I
have "6." And so on.

Thanks again!


--
chiliman
------------------------------------------------------------------------
chiliman's Profile: http://www.excelforum.com/member.php...o&userid=34567
View this thread: http://www.excelforum.com/showthread...hreadid=543378