Formulas
I'm a teacher and I'm trying to use exel to do grades. How do I find the
total for a row of grades and then find the average against total points possible? HELP! |
Formulas
Marie, is this what you need?
=SUM(A1:I1) =AVERAGE(A1:I1) -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Marie" wrote in message ... I'm a teacher and I'm trying to use exel to do grades. How do I find the total for a row of grades and then find the average against total points possible? HELP! |
Formulas
Marie wrote:
I'm a teacher and I'm trying to use exel to do grades. How do I find the total for a row of grades That depends on the form of grades. If they are numeric points, the answer is simple. If the grades are in the cell range A2:J2, then enter: =sum(A2:J2) If you have letter grades, you will need to convert each letter grade to whatever point system you might have; and perhaps you will have to convert the sum or the average back to a letter grade, if that is your intent. Since that is much more involved, before overwhelming you with potentially irrelevant information, please indicate your interest in this solution. and then find the average against total points possible? Do you mean "find the average of the row of grades", or do you perhaps mean "find the percentage of the total possible points"? If you mean the former, enter: =average(A2:J2) If you mean the latter, as I suspect, if the total possible points is in A1, then enter: =sum(A2:J2) / A1 You might want to format that as Percentage with 1 or 2 decimal places. To do so, click on Format Cells Number and select Percentage. HTH |
All times are GMT +1. The time now is 12:50 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com