I put 'table1' in fornt of all the c9,c17,c25 j9 s... ect, but all I am
getting is 9, no mater what I enter into the fields.

Steve


"Ken Johnson" wrote in message
oups.com...
Hi Steve,
39=0 OK
40=1 OK
42=3 OK?
Now, 1 + 3 = 4 OK?
How come you get 3?

My (yukky) formula is:

=(SUM(C9,C17,C25,J9,J17,J25) - 6*39 + ABS(C9-39) + ABS(C17-39) +
ABS(C25-39)+ ABS(J9-39) + ABS(J17-39) + ABS(J25-39))/2

which gives the result 4 with the values supplied.

Ken Johnson