no its still not working. I am not even getting a result.

Steve

"Bob Phillips" wrote in message
...
Try

=SUMPRODUCT(--(N(OFFSET('table1'!C9:C25,{0,8,16},0,1,1))=39))+S UMPRODUCT(--
(N(OFFSET('table1'!J9:J25,{0,8,16},0,1,1))=39))


--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"R.P.McMurphy" wrote in message
...
I have changed it to

=SUMPRODUCT(--(N(OFFSET(table1 C9:table1
C25,{0,8,16},0,1,1))=39))+SUMPRODUCT(--(N(OFFSET(table1 J9:table1
J25,{0,8,16},0,1,1))=39))

but its still not working,

help!

Steve
"Bob Phillips" wrote in message
...
How about


=SUMPRODUCT(--(N(OFFSET(C9:C25,{0,8,16},0,1,1))=39))+SUMPRODUCT (--(N(OFFSET
(J9:J25,{0,8,16},0,1,1))=39))

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"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