I'm creating a grade book for a friend of mine and have everything finished except for one small thing.
I'm trying to keep a running tally of sorts as grades are input. For example in the image i attached I want to compute to correct percentage of the first 4 quizzes. As it sits now its just basically dividing the total percentages by 4 but that is not the correct weighed average. how can i go about doing this? thanks in advance
[img=http://img299.imageshack.us/img299/7409/exampleqx8.th.jpg]
Hi
Try
G31: =SUMPRODUCT(--(G17:G30<>"Not Completed"),(F17:F30))/SUMPRODUCT(--(G17:G30<>"Not Completed"),(E17:E30))
HTH
rylo
thank you that worked perfectly!
would you mind explaining how that works precisely so i may set it up for other areas in the workbook?
The numerator,
Determines which cells in G17:G30 are not equal to (<>) "Not Completed", and assigns a 1 if TRUE or 0 if FALSE. It then multiplies the 1's and 0's by the values in F17:F30 and then SUM's the products of these values. Based on your example, it's doing this:
Please Login or Register to view this content.
Next, the denominator (after the "/") does the same thing, but with columns G and E. This determines the total points possible (90) as shown below:Please Login or Register to view this content.
It then divides the numerator (89) by the denominator (90) and returns your correct average.Please Login or Register to view this content.
Last edited by Paul; 06-10-2007 at 11:06 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks