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.
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
The order of the columns must stay the same, sorry.
Code:
=((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