May 18 2020 03:32 AM
Hi,
I'm struggling to put this into words (let alone write a formula for it) so hopefully you can understand what I mean.
I am a teacher and I have an excel document where I record the marks each student receives in their tasks completed during class, for example in lesson 1 we might do 3 tasks and a student scores 3/4, 1/4 and 5/6; in lesson 2 they score 4/6 and 5/5; and in lesson 3 they score 1/2, 3/3 and 3/3.
I then have a second sheet which calculates their score into an overall percentage (by dividing by the total of all questions, in the above example 33). The problem is, if a student misses a lesson their score goes down significantly - I would like to calculate only the percentage of the scores that have been filled in.
Hopefully someone can help me achieve this.
Thanks,
Darren.
May 18 2020 04:56 AM
@MrCampbellPE you can do something like attached file.
May 18 2020 08:37 AM
Hi Darren,
I attach a slightly different solution which hopefully will give what you want.
I have kept it all on one sheet so that you could see the totals and calculations but there is no reason why you can't move the totals to a second sheet.
hope this helps you!
Peter
May 18 2020 10:26 AM
@MrCampbellPE There are many ways to do things so here is one way.
May 22 2020 08:13 AM