I have the following formula that works correctly. The formulas is used to
calculate grades for my classroom.

=IF(COUNT(G8:P8,U8,V8)<12,"",VLOOKUP(SUM(G8:P8,U8: V8/(SUMIF(G8:P8,"0",$G$7:$P$7)+SUMIF(U8:V8,"0",$U$7 :$V$7)),GradeTbl,2))

What I am trying to do is weigh the grades so the range G8:P8 constitute 40%
of the grade and the range U8:V8 constitue 60% of the grade, then using
Vlookup show the grade.

I have tried Sum((G8:P8)*.4),(U8:V8)*.6)) in the SUM(G8:P8,U8:V8 part of the
formula but get an error message. I have tried others with no success.

Is it possible to accomplish what I am trying to do with one formula?

Thank you.