Using Macro to automatically sum a variable range of rows?

I am trying to create a macro that will automatically sum a variablerange of rows. Simple example.

Price Qty

1 104 206 3010 40

------5 717 1019 425 330 136 0

The rows of data will always start on the same row so I have triedjust doing a CRTL+ down arrow. How do you convey, in VB Excel, tomove down 2 additional rows and then sum the range above?

It would be interesting to see some code for doing this if the startrow is different but that's not in the immediate focus of my question.

I tried doing this by recording the macro and doing the keystrokesnecessary to get the result, but I am at a loss on what to do to editthe VB code of the macro to achieve my goal so it works on variablerow ranges.