...
The alternating rows (highlighting added for demonstration) contain sum formulas, visible in the function bar below:
The sum formula is the a standard Excel function. When the data is populated, the A1:A1 reference gets updated to include all the data. The result should be something like this (highlighting added for demonstration):
...