Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding cels in a row that correspond to the heading of a column
i have a spreadsheet that keeps track of attendance, assignments and grades
of a class. Each week has three columns associated with it. The rows correspond to the names of the students. So, for the student in row 6, I would have grades in columns M, P, S, V. Y, AB, AE, AH and AK. The heading of the column is "Grade". How can I write a formula that will count each cell in a row that has a grade and divide it by the number of grades in the row and give me the grade percent? Not all students have grades in each week, but I would like to have a grade percentage available any week the teacher looks at the spreadsheet. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding cels in a row that correspond to the heading of a column
On Jun 27, 2:24 pm, OfficeManager
wrote: i have a spreadsheet that keeps track of attendance, assignments and grades of a class. Each week has three columns associated with it. The rows correspond to the names of the students. So, for the student in row 6, I would have grades in columns M, P, S, V. Y, AB, AE, AH and AK. The heading of the column is "Grade". How can I write a formula that will count each cell in a row that has a grade and divide it by the number of grades in the row and give me the grade percent? Not all students have grades in each week, but I would like to have a grade percentage available any week the teacher looks at the spreadsheet. Ok, do you want to count or add up the grades? Sounds like you want to add them up. Try =AVERAGE(M6,P6,S6,V6,Y6,AB6,AE6,AH6,AK6) If the grades are already percentages (80=B, 90=A, etc), you are done. If not, you'll have to calculate the percent depending on how the grades are determined. But you didn't give that info. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding cels in a row that correspond to the heading of a colum
Thank you, this is very helpful. This works great if the student has taken
any of the test. However, some of my students do not have grades in any of the columns. How can I show nothing in the cell if the formula brings back a #DIV/0 because there are no grades in any of the cells? "Spiky" wrote: On Jun 27, 2:24 pm, OfficeManager wrote: i have a spreadsheet that keeps track of attendance, assignments and grades of a class. Each week has three columns associated with it. The rows correspond to the names of the students. So, for the student in row 6, I would have grades in columns M, P, S, V. Y, AB, AE, AH and AK. The heading of the column is "Grade". How can I write a formula that will count each cell in a row that has a grade and divide it by the number of grades in the row and give me the grade percent? Not all students have grades in each week, but I would like to have a grade percentage available any week the teacher looks at the spreadsheet. Ok, do you want to count or add up the grades? Sounds like you want to add them up. Try =AVERAGE(M6,P6,S6,V6,Y6,AB6,AE6,AH6,AK6) If the grades are already percentages (80=B, 90=A, etc), you are done. If not, you'll have to calculate the percent depending on how the grades are determined. But you didn't give that info. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding Column Heading w/o Using a Row Number | Excel Discussion (Misc queries) | |||
Adding Columns/Heading | Excel Discussion (Misc queries) | |||
Autofill cels based on two dates in adjacent cels | Excel Worksheet Functions | |||
In a table produce an value by column heading and row heading | Excel Worksheet Functions | |||
column heading | Excel Discussion (Misc queries) |