Hi,

I have a table that has a column (L) full of test scores. The table is separated into different test and the number can change depending on how many took the test.

Is there a formula i can drag down that would calculate a total for the above scores for each test which is separated by the different tests?


Here a a pic of what i am trying a formula to achieve;


Forum_Totals.jpg



Much thanks!