I have 20 students with 6 grades entered for most of them-How do I average them?
S sally nbct '02 Dec 28, 2008 #1 I have 20 students with 6 grades entered for most of them-How do I average them?
S Shane Devenshire Dec 28, 2008 #2 Hi, Suppose the 6 grades are in B1:G1 and the student name in A1, enter =AVERAGE(B1:G1) copy it down for all the students. If this helps, please click the Yes button Cheers, Shane Devenshire
Hi, Suppose the 6 grades are in B1:G1 and the student name in A1, enter =AVERAGE(B1:G1) copy it down for all the students. If this helps, please click the Yes button Cheers, Shane Devenshire
B Bernard Liengme Dec 29, 2008 #3 And have a look at SUMPRODUCT if you want a final grade based on different weighting for each mark. best wishes
And have a look at SUMPRODUCT if you want a final grade based on different weighting for each mark. best wishes
