Calculating %'s with IF and Sum/SumIF
Your formula refers to data in row 7, but your example shows nothing, and
what about GradeTbl?
--
HTH
Bob
"Billy B" wrote in message
...
"Bob Phillips" wrote:
It seems to be a missing ), this was allowed
=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))
but can you show some data t try it on
--
HTH
Bob
"Billy B" wrote in message
...
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.
Rows G H I J K L M N O P
Q
R S U V W
7
8 Possible 10 10 10 10 10 10 10 10 10 10
20
20
9 Earned 9 10 10 8 10 10 8 10 7 10
16 15 =IF....
and the formula in W9, copied and pasted:
=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))
Hope this helps....thanks again
|