Formula to calculate % only of filled in cells

[MrCampbellPE]

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.

[#2]

@MrCampbellPE you can do something like attached file.

[#3]

@MrCampbellPE 

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

[#4]

@MrCampbellPE  There are many ways to do things so here is one way.

[#5]

Excellent guys, thank you.

[#6]

@MrCampbellPE 

Hi Darren,

Can you please mark the solution as complete. Many thanks!

Peter