Multiple Totals In Table At Every Blank Row?

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!

Thanks for the swift reply Paul but i get a "circular reference warning"??

That worked perfectly

Thanks Paul... feedback left!