Ada yang bisa meringkas rumus di bawah ini?
=SUM(G2:I2,L2,N2,Q2:R2,V2,Z2:AB2,AD2,AG2,AI2,AK2:AL2,IF(F2=1,"5", IF(F2=2,"4", IF(F2=3,"3",IF(F2=4,"2", IF(F2=5,"1"))))),IF(J2=1,"5", IF(J2=2,"4", IF(J2=3,"3",IF(J2=4,"2", IF(J2=5,"1"))))),IF(K2=1,"5", IF(K2=2,"4", IF(K2=3,"3",IF(K2=4,"2", IF(K2=5,"1"))))),IF(M2=1,"5", IF(M2=2,"4", IF(M2=3,"3",IF(M2=4,"2", IF(M2=5,"1"))))),IF(O2=1,"5", IF(O2=2,"4", IF(O2=3,"3",IF(O2=4,"2", IF(O2=5,"1"))))),IF(P2=1,"5", IF(P2=2,"4", IF(P2=3,"3",IF(P2=4,"2", IF(P2=5,"1"))))),IF(S2=1,"5", IF(S2=2,"4", IF(S2=3,"3",IF(S2=4,"2", IF(S2=5,"1"))))),IF(T2=1,"5", IF(T2=2,"4", IF(T2=3,"3",IF(T2=4,"2", IF(T2=5,"1"))))),IF(U2=1,"5", IF(U2=2,"4", IF(U2=3,"3",IF(U2=4,"2", IF(U2=5,"1"))))),IF(W2=1,"5", IF(W2=2,"4", IF(W2=3,"3",IF(W2=4,"2", IF(W2=5,"1"))))),IF(X2=1,"5", IF(X2=2,"4", IF(X2=3,"3",IF(X2=4,"2", IF(X2=5,"1"))))),IF(Y2=1,"5", IF(Y2=2,"4", IF(Y2=3,"3",IF(Y2=4,"2", IF(Y2=5,"1"))))),IF(AC2=1,"5", IF(AC2=2,"4", IF(AC2=3,"3",IF(AC2=4,"2", IF(AC2=5,"1"))))),IF(AE2=1,"5", IF(AE2=2,"4", IF(AE2=3,"3",IF(AE2=4,"2", IF(AE2=5,"1"))))),IF(AF2=1,"5", IF(AF2=2,"4", IF(AF2=3,"3",IF(AF2=4,"2", IF(AF2=5,"1"))))),IF(AH2=1,"5", IF(AH2=2,"4", IF(AH2=3,"3",IF(AH2=4,"2", IF(AH2=5,"1"))))),IF(AJ2=1,"5", IF(AJ2=2,"4", IF(AJ2=3,"3",IF(AJ2=4,"2", IF(AJ2=5,"1"))))),IF(AM2=1,"5", IF(AM2=2,"4", IF(AM2=3,"3",IF(AM2=4,"2", IF(AM2=5,"1"))))))