Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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! |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to change column letters to correct ones in many formulas automatically? | Links and Linking in Excel | |||
how can i get formulas in excel to copy and paste? | Excel Worksheet Functions | |||
How to make Excel run limited number of formulas on a given worksh | Excel Discussion (Misc queries) | |||
Way to make Excel only run certain formulas on a worksheet? | Excel Discussion (Misc queries) | |||
calculating formulas for all workbooks in a folder | Excel Worksheet Functions |