Autosum Dynamic Range

[uberathlete]

Hi everyone. Would really appreciate assistance on this.

Please see attached.

I would like a formula to be added to the highlighted cell equal to the sum of whatever values are above it but not including the item amounts. So in this case, the formula should =sum(E20:E21) .


The problem is that there will be times when there will be no Shipping row, or there may be 2 or more Shipping rows, and the number of items can vary.

This would be part of a larger macro code. Any suggestions would be much appreciated!

[davesexcel]

Check out the attached example, click the button to get the first sun-total. Enter the Shipping Info. Click the second button to get the subtotal and shipping total.

Here are the codes used in the example.

Please Login or Register  to view this content.