View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Centauro Centauro is offline
external usenet poster
 
Posts: 8
Default simplify a large formula

hi i new to this so don't be to hard on me :) I have to sum several cell whit
this formula on it,
=(IF(C13=0,0,AC1)+IF(D13=0,0,AC2)+IF(F13=0,0,AC2)) *(IF(OR(N13="P",N13="M"),1,0)+IF(OR(O13="P",O13="M "),1,0)+IF(OR(P13="P",P13="M"),1,0)+IF(OR(Q13="P", Q13="M"),1,0)+IF(OR(R13="P",R13="M"),1,0)+IF(OR(S1 3="P",S13="M"),1,0)+IF(OR(T13="P",T13="M"),1,0)+IF (OR(U13="P",U13="M"),1,0)+IF(OR(V13="P",V13="M"),1 ,0)+IF(OR(W13="P",W13="M"),1,0)+IF(OR(X13="P",X13= "M"),1,0)+IF(OR(Y13="P",Y13="M"),1,0))

and then

=SUM(AE13:AE24)

tks in advance