Calculations on first lines for entire groups of data in a single column

[Hyflex]

Hey,

I'm looking to do some simple maths with ranges in Excel but I'd like a way to be able to input all these formulas automatically although I am pretty sure a single formula per column could do it all automatically.
I've got to put the sums in AD to AF on the first line of each location, but the maths is for the entire location's range.

What's the best way to do it?

See the following screenshot: http://i.imgur.com/fAFxJps.png Or see the attached document