Hi,
I have a large data set of student exam results where I am trying to return the result of the calculation =SUM(range)/100, where the range is a dynamic number of exam results (one per row), for each student. As shown in the below example, the range is the Weighted Exam Scores for each student and the result of =SUM(range)/100 should be returned in column 'Weighted Avg.Score' in the first row of each student. Can anyone suggest some VBA code to do this please?


Student Number Exam Credit
Exam Score
Weighted Exam Score Weighted Avg. Score
01 20 11 210 8.1
01 20 10 200
01 40 8 320
01 20 4 80
02 10 14 140 12.1
02 10 15 150
02 60 13 780
02 20 7 140
03 20 7 140 10.2
03 40 13 520
03 40 13 520
04 10 12 120 11.9
04 10 13 130
04 50 13 650
04 20 10 200
04 10 9 90
05 40 12 480 10.8
05 40 10 400
05 20 10 200