Gostaria de saber se tem como resumir essa fórmula, está repetitiva, a diferença de uma pra outra é que fiz manualmente a troca das colunas de C pra D,E,F,G... Na formatação condicional ela faz essa troca automática só de selecionar os intervalos.

=SE(E(OU(D12="C";D12="X";D12="\";D12="Z");NÃO(OU(E12="C";E12="X";E12="\";E12="Z")));1;0)+
SE(E(OU(E12="C";E12="X";E12="\";E12="Z");NÃO(OU(F12="C";F12="X";F12="\";F12="Z")));1;0)+
SE(E(OU(F12="C";F12="X";F12="\";F12="Z");NÃO(OU(G12="C";G12="X";G12="\";G12="Z")));1;0)+
SE(E(OU(G12="C";G12="X";G12="\";G12="Z");NÃO(OU(H12="C";H12="X";H12="\";H12="Z")));1;0)+
SE(E(OU(H12="C";H12="X";H12="\";H12="Z");NÃO(OU(I12="C";I12="X";I12="\";I12="Z")));1;0)+
SE(E(OU(I12="C";I12="X";I12="\";I12="Z");NÃO(OU(J12="C";J12="X";J12="\";J12="Z")));1;0)+
SE(E(OU(J12="C";J12="X";J12="\";J12="Z");NÃO(OU(K12="C";K12="X";K12="\";K12="Z")));1;0)+
SE(E(OU(K12="C";K12="X";K12="\";K12="Z");NÃO(OU(L12="C";L12="X";L12="\";L12="Z")));1;0)+
SE(E(OU(L12="C";L12="X";L12="\";L12="Z");NÃO(OU(M12="C";M12="X";M12="\";M12="Z")));1;0)+
SE(E(OU(M12="C";M12="X";M12="\";M12="Z");NÃO(OU(N12="C";N12="X";N12="\";N12="Z")));1;0)+
SE(E(OU(N12="C";N12="X";N12="\";N12="Z");NÃO(OU(O12="C";O12="X";O12="\";O12="Z")));1;0)+
SE(E(OU(O12="C";O12="X";O12="\";O12="Z");NÃO(OU(P12="C";P12="X";P12="\";P12="Z")));1;0)+
SE(E(OU(P12="C";P12="X";P12="\";P12="Z");NÃO(OU(Q12="C";Q12="X";Q12="\";Q12="Z")));1;0)+
SE(E(OU(Q12="C";Q12="X";Q12="\";Q12="Z");NÃO(OU(R12="C";R12="X";R12="\";R12="Z")));1;0)+
SE(E(OU(R12="C";R12="X";R12="\";R12="Z");NÃO(OU(S12="C";S12="X";S12="\";S12="Z")));1;0)+
SE(E(OU(S12="C";S12="X";S12="\";S12="Z");NÃO(OU(T12="C";T12="X";T12="\";T12="Z")));1;0)+
SE(E(OU(T12="C";T12="X";T12="\";T12="Z");NÃO(OU(U12="C";U12="X";U12="\";U12="Z")));1;0)+
SE(E(OU(U12="C";U12="X";U12="\";U12="Z");NÃO(OU(V12="C";V12="X";V12="\";V12="Z")));1;0)+
SE(E(OU(V12="C";V12="X";V12="\";V12="Z");NÃO(OU(W12="C";W12="X";W12="\";W12="Z")));1;0)+
SE(E(OU(W12="C";W12="X";W12="\";W12="Z");NÃO(OU(X12="C";X12="X";X12="\";X12="Z")));1;0)+
SE(E(OU(X12="C";X12="X";X12="\";X12="Z");NÃO(OU(Y12="C";Y12="X";Y12="\";Y12="Z")));1;0)+
SE(E(OU(Y12="C";Y12="X";Y12="\";Y12="Z");NÃO(OU(Z12="C";Z12="X";Z12="\";Z12="Z")));1;0)+
SE(E(OU(Z12="C";Z12="X";Z12="\";Z12="Z");NÃO(OU(AA12="C";AA12="X";AA12="\";AA12="Z")));1;0)+
SE(E(OU(AA12="C";AA12="X";AA12="\";AA12="Z");NÃO(OU(AB12="C";AB12="X";AB12="\";AB12="Z")));1;0)+
SE(E(OU(AB12="C";AB12="X";AB12="\";AB12="Z");NÃO(OU(AC12="C";AC12="X";AC12="\";AC12="Z")));1;0)+
SE(E(OU(AC12="C";AC12="X";AC12="\";AC12="Z");NÃO(OU(AD12="C";AD12="X";AD12="\";AD12="Z")));1;0)+
SE(E(OU(AD12="C";AD12="X";AD12="\";AD12="Z");NÃO(OU(AE12="C";AE12="X";AE12="\";AE12="Z")));1;0)+
SE(E(OU(AE12="C";AE12="X";AE12="\";AE12="Z");NÃO(OU(AF12="C";AF12="X";AF12="\";AF12="Z")));1;0)+
SE(E(OU(AF12="C";AF12="X";AF12="\";AF12="Z");NÃO(OU(AG12="C";AG12="X";AG12="\";AG12="Z")));1;0)+
SE(E(OU(AG12="C";AG12="X";AG12="\";AG12="Z");NÃO(OU(AH12="C";AH12="X";AH12="\";AH12="Z")));1;0)+
SE(E(OU(AH12="C";AH12="X";AH12="\";AH12="Z");NÃO(OU(AI12="C";AI12="X";AI12="\";AI12="Z")));1;0)+
SE(E(OU(AI12="C";AI12="X";AI12="\";AI12="Z");NÃO(OU(AJ12="C";AJ12="X";AJ12="\";AJ12="Z")));1;0)+
SE(E(OU(AJ12="C";AJ12="X";AJ12="\";AJ12="Z");NÃO(OU(AK12="C";AK12="X";AK12="\";AK12="Z")));1;0)+
SE(E(OU(AK12="C";AK12="X";AK12="\";AK12="Z");NÃO(OU(AL12="C";AL12="X";AL12="\";AL12="Z")));1;0)+
SE(E(OU(AL12="C";AL12="X";AL12="\";AL12="Z");NÃO(OU(AM12="C";AM12="X";AM12="\";AM12="Z")));1;0)+
SE(E(OU(AM12="C";AM12="X";AM12="\";AM12="Z");NÃO(OU(AN12="C";AN12="X";AN12="\";AN12="Z")));1;0)+
SE(E(OU(AN12="C";AN12="X";AN12="\";AN12="Z");NÃO(OU(AO12="C";AO12="X";AO12="\";AO12="Z")));1;0)+
SE(E(OU(AO12="C";AO12="X";AO12="\";AO12="Z");NÃO(OU(AP12="C";AP12="X";AP12="\";AP12="Z")));1;0)+
SE(E(OU(AP12="C";AP12="X";AP12="\";AP12="Z");NÃO(OU(AQ12="C";AQ12="X";AQ12="\";AQ12="Z")));1;0)+
SE(E(OU(AQ12="C";AQ12="X";AQ12="\";AQ12="Z");NÃO(OU(AR12="C";AR12="X";AR12="\";AR12="Z")));1;0)+
SE(E(OU(AR12="C";AR12="X";AR12="\";AR12="Z");NÃO(OU(AS12="C";AS12="X";AS12="\";AS12="Z")));1;0)+
SE(E(OU(AS12="C";AS12="X";AS12="\";AS12="Z");NÃO(OU(AT12="C";AT12="X";AT12="\";AT12="Z")));1;0)