Tim,
Thank you for your quick response!
I'm not familiar with OFFSET function but I will look it up in my book and
then try it..... could I send you my spreadsheet so you see how my long
formula is being used?
jane

"Tim C" wrote:

I haven't tested it, but try this:

=(OFFSET(J2,H17,0)=H17)*(OFFSET(J3,H17,0)<"N")*OF FSET(K5,0,(F173)+(F176))

Tim C

"Jane" wrote in message
...
CORRECTION - THIS is the formula that is too long and I'm not sure how to
shorten it.... thanks in advance!! jane


'=IF(AND(K$2=1,H17=1,K$3<"n"),IF(OR(F17=1,F17=2,F 17=3),K$5)+IF(OR(F17=4,F17=5,F17=6),L$5)+IF(OR(F17 =7,F17=8,F17=9,F17=10),M$5))+IF(AND(L$2=2,H17=2,L$ 3<"N"),IF(OR(F17=1,F17=2,F17=3),K$5)+IF(OR(F17=4, F17=5,F17=6),L$5)+IF(OR(F17=7,F17=8,F17=9,F17=10), M$5))+IF(AND(M$2=3,H17=3,M$3<"N"),IF(OR(F17=1,F17 =2,F17=3),K$5)+IF(OR(F17=4,F17=5,F17=6),L$5)+IF(OR (F17=7,F17=8,F17=9,F17=10),M$5))+IF(AND(N$2=4,H17= 4,N$3<"N"),IF(OR(F17=1,F17=2,F17=3),K$5)+IF(OR(F1 7=4,F17=5,F17=6),L$5)+IF(OR(F17=7,F17=8,F17=9,F17= 10),M$5))+IF(AND(O$2=5,H17=5,O$3<"N"),IF(OR(F17=1 ,F17=2,F17=3),K$5)+IF(OR(F17=4,F17=5,F17=6),L$5)+I F(OR(F17=7,F17=8,F17=9,F17=10),M$5))+IF(AND(P$2=6, H17=6,P$3<"N"),IF(OR(F17=1,F17=2,F17=3),K$5)+IF(O R(F17=4,F17=5,F17=6),L$5)+IF(OR(F17=7,F17=8,F17=9, F17=10),M$5))+IF(AND(Q$2=7,H17=7,Q$3<"N"),IF(OR(F 17=1,F17=2,F17=3),K$5)+IF(OR(F17=4,F17=5,F17=6),L$ 5)+IF(OR(F17=7,F17=8,F17=9,F17=10),M$5))+IF(AND(R$ 2=8,H17=8,R$3<"N"),IF(OR(F17=1,F17=2,F17=3),K$5)+ IF(OR(F17=4,F17=5,F17=6),L$5)+IF(OR(F17=7,F17=8,F1 7=9,F17=10),M$5))+IF(AND(s$2=9,H17=9,s$3<"N"),IF( OR(F17=1,F17=2,F17=3),K$5)+IF(OR(F17=4,F17=5,F17=6 ),L$5)+IF(OR(F17=7,F17=8,F17=9,F17=10),M$5))+IF(AN D(t$2=10,H17=10,t$3<"N"),IF(OR(F17=1,F17=2,F17=3) ,K$5)+IF(OR(F17=4,F17=5,F17=6),L$5)+IF(OR(F17=7,F1 7=8,F17=9,F17=10),M$5))