How to shorten an Excel formula?

Durdanto D August 14, 2013
Pinterest Stumbleupon Whatsapp

Can anyone help me to shorten the following formula please?
=SUM(IF(G58=”fare query”,I58=”kul”))+(IF(G59=”fare query”,I59=”kul”))+(IF(G60=”fare query”,I60=”kul”))+(IF(G61=”fare query”,I61=”kul”))+(IF(G62=”fare query”,I62=”kul”))+(IF(G63=”fare query”,I63=”kul”))+(IF(G64=”fare query”,I64=”kul”))+(IF(G65=”fare query”,I65=”kul”))+(IF(G66=”fare query”,I66=”kul”))+(IF(G67=”fare query”,I67=”kul”))+(IF(G68=”fare query”,I68=”kul”))+(IF(G69=”fare query”,I69=”kul”))+(IF(G70=”fare query”,I70=”kul”))+(IF(G71=”fare query”,I71=”kul”))+(IF(G72=”fare query”,I73=”kul”))+(IF(G74=”fare query”,I74=”kul”))+(IF(G75=”fare query”,I75=”kul”))+(IF(G76=”fare query”,I76=”kul”))+(IF(G77=”fare query”,I77=”kul”))+(IF(G78=”fare query”,I78=”kul”))+(IF(G79=”fare query”,I79=”kul”))+(IF(G80=”fare query”,I80=”kul”))+(IF(G81=”fare query”,I81=”kul”))+(IF(G82=”fare query”,I82=”kul”))+(IF(G83=”fare query”,I83=”kul”))+(IF(G84=”fare query”,I84=”kul”))+(IF(G85=”fare query”,I85=”kul”))+(IF(G86=”fare query”,I86=”kul”))+(IF(G87=”fare query”,I87=”kul”))+(IF(G88=”fare query”,I88=”kul”))+(IF(G89=”fare query”,I89=”kul”))+(IF(G90=”fare query”,I90=”kul”))

Ads by Google