Dynamic Range Add Rows and Sum/Subtotal row Formula or VBA?

Hi I am having trouble understanding dynamic range as a way to programatically add rows based on the value in a cell. Once I have been able to do that I need to dynamically add a set of formulas across the new columns and dynamically sum the columns. The screen shots are of the Excel attachment.

Thanks in advance.

Tim

Here is what the array looks like with a row length value of 12. I want to expand or reduce based on the value in D2
ScreenShot.jpg

Here is what the array looks like with a row length value of 24. I want to expand or reduce based on the value in D2
ScreenShot2.jpg

Dynamic Range Formula Help=2.xlsx

Not quite what I was I was looking for. I am trying to add an entire N# of rows based on the value in D2 such that if it is 6 there are 6 rows starting in A13:P18 or if there are 17 rows there are 17 rows staring in A13:p29. Once the number of rows is inputed into cell in D2 the new number of rows will include all formulas from what are currently in cells A13:p13. I then need a total row that sums the range above it (as is seen in the screenshot E25:P25 when the number of rows is 12). Does this make sense? Thanks in advance.

Tim

To do that you might consider VBA. Sorry I couldn't help.