my formula is too long and parts are repetitive but I am not sure how to
shorten it.... any help is appreciated! here it is:
'=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))