VBA for a calculation where the range is dynamic

[lgare]

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

[Bob Phillips]

You don't need VBA, a simple formula will suffice

=IF(A2<>A1,SUMIF(A:A,A2,D:D)/100,"")

[lgare]

This worked beautifully, many thanks!