Function help please!
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
|