Moving Cell Contents in a Certain Direction Based on Another Cell's Contents

Here is an example of what I want.

Let X be any natural number ≤ 1,048,576
If cell HX ≠ 0, then cell A(2+X) = "Totals"

For example:
If cell H10 ≠ 0 , then cell A(2+10) = A12 = "Totals"

Let me describe what I am doing. In a given row I am placing three numbers in different columns and then calculating the sum of these numbers (a sub-total) in the right-most column of the given row. In the bottom row of the right most column I am calculating the grand total. Currently, if obtain three subtotals, the grand total is calculated at the very bottom of the page. I want the grand total to automatically two rows from the last sub-total. I want to be able to add an entry and then have the grand total automatically move down again.

The reason I want to do this is because I do not want a huge amount of blank space between the most recent sub-total and the grand total.

Is this possible to do in excel?

I appreciate your help.

Hi,

Are you able to attach a sample from your Data file?
It may be possible by converting your "Range" to a "Table" as the "Table Total Row" automatically moves down as you add more Rows.
However, it does depend on how your Data is laid out.

Regards

peterrc

I have attached a sample of what I am wanting to do under the extension .xlsx . There are two sheets, ¨Statement of Cash Flows¨ and ¨Business Mileage.¨
¨Business Mileage¨operates the way I want it to. You will see what I mean if you fill in the boxes, the ¨Total Deduction¨amount will move down
with each new entry rather than stay at the very bottom.

I am having an error with the ¨Statement of Cash Flows¨ sheet. The first couple of entries I make will work fine, but as you will see
on the particular line I stopped on, I am getting the error ¨VALUE!¨when attempting to do the following ¨G11=-D11+E11-F11".

Take a look for yourself to get the best idea of what is going on.

Kaper , thank you for your suggestion. I tried it and it got me to this point, which is further than what I was yesterday before reading your response.

Hi,

I have simply opened your last attachment, clicked "Formulas" then "Show Formulas" and as you can see there are formulas everywhere!
Are all these formulas supposed to be there?
Please advise.

Regards

peterrc

Hi Kaper,

I think you've got me mixed up with the OP - I was commenting on the OP's (Cloud909) last attachment.

Regards

peterrc

Sorry peterrc,

Indeed it sounded like OP post commenting my answer (#5), so I haven't checked who posted. My fault.

Anyway - I probably answered (hopefully in line with OP's idea) your question.

Have a good day :-)

Thank you for your suggestion. This is exactly what I needed. I took an excel course at my local university, but I'm still learning more now that I'm trying to apply it.

The formulas are supposed to be there. I'm making this spreadsheet for a very specific purpose, and once I have finished setting everything up the way I want it, I plan on locking a bunch of cells so it is idiot proof.