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

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

[Hyflex]

Hey JOHN H. DAVIS,

I can kind of see what you've done but I'm unable to work out why it's erroring out on the

Please Login or Register  to view this content.

I like your approach to it by the way, kind of obvious and I completely missed it.

[JOHN H. DAVIS]

When I test it on your sample it works. What error are you getting?