Simplifying equation - ????

[spydey]

Just out of curiosity, is there an easier way to do this equation? Meaning, can I simplify this equation to any degree?

The order of the columns must stay the same, sorry.

=((15*SUMIF($G3:$H3,"<>"&"N/A"))+(10*SUMIF($I3:$K3,"<>"&"N/A"))+(15*SUMIF($L3,"<>"&"N/A"))+(5*SUMIF($M3,"<>"&"N/A"))+(15*SUMIF($N3,"<>"&"N/A"))+(5*SUMIF($O3,"<>"&"N/A"))-(5*$P3))/(100-((15*COUNTIF($G3:$H3,"N/A"))+(10*COUNTIF($I3:$K3,"N/A"))+(15*COUNTIF($L3,"N/A"))+(5*COUNTIF($M3,"N/A"))+(15*COUNTIF($N3,"N/A"))+(5*COUNTIF($O3,"N/A"))))

I was just curious if maybe I am making it more complicated than it really needs to be .... I tend to do that for some reason ....

Thanks y'all

-Spydey

 

[Eric W]

This seems to do the same thing:

=SUM(IF($G3:$P3<>"N/A",$G3:$P3*{15,15,10,10,10,15,5,15,5,-5}))/(100-SUM(($G3:$O3="N/A")*{15,15,10,10,10,15,5,15,5}))

confirmed with Control+Shift+Enter.

 

[spydey]

This seems to do the same thing:

=SUM(IF($G3:$P3<>"N/A",$G3:$P3*{15,15,10,10,10,15,5,15,5,-5}))/(100-SUM(($G3:$O3="N/A")*{15,15,10,10,10,15,5,15,5}))

confirmed with Control+Shift+Enter.

Eric my man!!! Awesome work. I hadn't even thought about using an array to simplify it.

Thank you a million man for your assistance. I was content with using the formula I had but was kind of annoyed that it was so long.

Thank you for you time. It is very much appreciated.

-Spydey

 

[Eric W]

Glad to help!