Hi All:

In row A1 through K1 I have either a positive 1, negative 1 or a 0.
In cell L1 I want to display the total.

The value in A1 through K1 is determined data entered into Row A2 through K2
via a lookup formula. If I type a number 1-6 in cell B2 then A1 will reflect
a 1. If I put in 7-9 in B1 then it puts a 0 value in A1. and if I put in the
letter A or the number 10 in B1 then it puts a -1 in cell A1.
It does this via a lookup formula: VLOOKUP(A2,$N$1:$O$10,2,FALSE) with N1
through N10 is 2 3 4 5 6 7 8 9 10 A
and O1 through O10 is 1 1 1 1 1 1 0 0 0 -1 -1

My main problem after the wordy description is that Cell L1 does not add up
properly. If cells B2 through K2 are 1 through 6 then it adds up fine. If one
of the numbers in cells B2 through K2 are 10 or A then it subtracts 2 from
the total instead of only subtracting 1 (is there something I should be using
besides Sum(A1:K1)
?

Thanks for your help. I am tryingt to write a sheet that computes the
running count using the simple plus minus count system. (for the gamblers of
you out there!)
Let me know if I need to explain differently.