Hi! Please please help! I am trying to make a template for my 2nd grade class and have spent hours, and can't figure it out! I want to create an average percentage. But when I make the average formula for every other column (for each assignment I enter in points, and then the second column calcs the percentage based on the points value/total points possible and color codes accordingly), it keeps taking the 0% into consideration. If I take out the total points possible, it still messes up the average formula. Please help if you can! The only things I have read online are about ranges of columns, not listing individual ones....Thank you!
<colgroup><col><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>
Math | Average Points | Average Percentage | Homework 1 | Homework 2 | Homework 3 | |||
Total Points Possible | 20 | 3 | 1 | |||||
Student | ||||||||
Aliana | 2 | 1% | 2 | 10% | 0% | 0% | ||
Aram | 0 | 0% | 0 | 0% | 0% | 0% | ||
Brenda | 0 | 0% | 0 | 0% | 0% | 0% | ||
Brianna | 0 | 0% | 0 | 0% | 0% | 0% | ||
Chad | 0 | 0% | 0 | 0% | 0% | 0% | ||
Diego | 0 | 0% | 0 | 0% | 0% | 0% |
<colgroup><col><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>