Hi,
Can you please help me to create a small macro to calculate % in the background and then do a summation on the sheet. Let me explain further.
I have 10 pupils and they wrote 3 tests. I must now calculate the results and report on how they did per test. There are 4 results brackets and I need to say how many pupils are within each bracket.
Here is my spreadsheet
<colgroup><col width="143" style="width: 107pt; mso-width-source: userset; mso-width-alt: 5091;">
<col width="47" style="width: 35pt; mso-width-source: userset; mso-width-alt: 1678;" span="2">
<col width="48" style="width: 36pt; mso-width-source: userset; mso-width-alt: 1706;">
<col width="82" style="width: 61pt; mso-width-source: userset; mso-width-alt: 2901;">
<tbody>
</tbody>
Thank you
Andre
Can you please help me to create a small macro to calculate % in the background and then do a summation on the sheet. Let me explain further.
I have 10 pupils and they wrote 3 tests. I must now calculate the results and report on how they did per test. There are 4 results brackets and I need to say how many pupils are within each bracket.
Here is my spreadsheet
Grade 5 | Test 1 20 points | Test 2 10 points | Test 3 15 points | |
Pupils points | Pupils points | Pupils points | ||
Pupil 1 | 6.00 | 5.00 | 8.00 | |
Pupil 2 | 2.00 | 4.00 | 6.00 | |
Pupil 3 | 10.00 | 6.00 | 9.50 | |
Pupil 4 | 15.00 | 6.00 | 12.50 | |
Pupil 5 | 12.50 | 5.00 | 10.00 | |
Pupil 6 | 9.00 | 5.50 | 11.50 | |
Pupil 7 | 12.00 | 5.50 | 11.00 | |
Pupil 8 | 17.00 | 8.00 | 14.00 | |
Pupil 9 | 11.00 | 3.50 | 7.50 | |
Pupil 10 | 16.00 | 7.00 | 13.00 | |
below 40 | ||||
from 40 to 60 | ||||
from 60.5 to 80 | ||||
above 80 |
Thank you
Andre