Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Gradebook Help Please
Not sure if this is possible. Let's say I made a gradebook set up like this Test 1 Test 2 Test 3 Possible Earned 1 Bob 10 10 4 25 24 2 Cindy 10 9 5 25 24 3 Sally 10 - 5 15 15 4 5 Possible 10 10 5 In other words I want it to figure each students possible, with a blank or - being an absent, and not counted as a 0 in the possible for the student. I guess it would have to somehow eliminate that value when adding up test possible point, IF that student didn't take the test. Hope that wasn't too confusing. It would just have to add the row 5, but if it found a - in each students grades, it would have to remove that value. -- LucasBuck ------------------------------------------------------------------------ LucasBuck's Profile: http://www.excelforum.com/member.php...o&userid=19710 View this thread: http://www.excelforum.com/showthread...hreadid=500302 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Gradebook Help Please
That was confusing, how about this: add up everything in A1:H1 which would be points earned add up everything in A15:H15 which would be points possible But if a student missed a test, and it showed up as a - in lets say, C1, it would go down to C15 and deduct that from the points possible. (If this is too hard, I'll just make them all work the same points) -- LucasBuck ------------------------------------------------------------------------ LucasBuck's Profile: http://www.excelforum.com/member.php...o&userid=19710 View this thread: http://www.excelforum.com/showthread...hreadid=500302 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Gradebook Help Please
You could create a new row under each name then under the test numbers put something like this in it , This example assumes that the first test number is in b2 and the possible number is in b8. =SUM(B8)*COUNTIF(B2,"0") Change the cells to the cells you are using -- keithl816 ------------------------------------------------------------------------ keithl816's Profile: http://www.excelforum.com/member.php...o&userid=21287 View this thread: http://www.excelforum.com/showthread...hreadid=500302 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Gradebook Help Please
Where are you getting the values to add to the "Possible" cell?
-- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "LucasBuck" wrote in message ... That was confusing, how about this: add up everything in A1:H1 which would be points earned add up everything in A15:H15 which would be points possible But if a student missed a test, and it showed up as a - in lets say, C1, it would go down to C15 and deduct that from the points possible. (If this is too hard, I'll just make them all work the same points) -- LucasBuck ------------------------------------------------------------------------ LucasBuck's Profile: http://www.excelforum.com/member.php...o&userid=19710 View this thread: http://www.excelforum.com/showthread...hreadid=500302 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Gradebook Help Please
Try something like this:
=SUM(A1:H1) =SUMPRODUCT(--(ISNUMBER(A1:H1)=TRUE),A15:H15) if a cell in A1:H1 is "-" (text) then the sumproduct will not add the corresponding value in A15:H15 Hope this helps! JG "LucasBuck" wrote: That was confusing, how about this: add up everything in A1:H1 which would be points earned add up everything in A15:H15 which would be points possible But if a student missed a test, and it showed up as a - in lets say, C1, it would go down to C15 and deduct that from the points possible. (If this is too hard, I'll just make them all work the same points) -- LucasBuck ------------------------------------------------------------------------ LucasBuck's Profile: http://www.excelforum.com/member.php...o&userid=19710 View this thread: http://www.excelforum.com/showthread...hreadid=500302 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Gradebook Template | Excel Discussion (Misc queries) | |||
Using Excel as a gradebook with ability to drop lowest grade | Excel Discussion (Misc queries) | |||
How can I get individual reports from excell gradebook? | Excel Discussion (Misc queries) | |||
excused assignment in the excel gradebook. | Excel Discussion (Misc queries) | |||
GradeBook | Excel Worksheet Functions |