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 120 points | Test 210 points | Test 315 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