Excel vba to work out average score
<p><a href="https://i.stack.imgur.com/byOSc.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/byOSc.png" alt="worksheet example"></a></p>

<p>the attached shows a small example of a scorecard i have at work for drivers, the list is many lines long, around 120 drivers, i export a report each week and it produces the attached, i have added code to tidy it up and work out scores. I then have to work out an average score for the week for each driver but can't for the life of me think how to do it using code. Any help would be appreciated.</p>