Columns E & G are blank - I add text to them - H is where the balance is automatically entered.
At the moment, if I add any entry below the last current row nothing happens to the total in the final column (H), I have to add rows above the last row to make it work. Is there a way I can make the total in the final column automatically move down and update as I add more data?
An additional refinement would be to have each column self-total as I added data, and for the final column total to ignore the self-totalling in the other columns.
Or am I getting ahead of myself? I can email a sample dummy file if it helps.
Thanks for responding. What I want to be able to do is enter data on a new row, and have the total from the final column in the row above automatically jump down a row, so that as I add new rows the total moves down with me.
If you copy the formula in Column H down as far as you wish (say to Row 100) the formula will not display anything if there isn't an entry in Columns C, D or F so it will not display a result until you make an entry in C, D or F on a new row.
That is a result of this part of the formula
which says if columns C, D and F are all blank on the current row, leave the cell in Column H blank. If C, D or F contain entries then the result of the second part of the formula
The trick here is to display the totals at the top of the sheet. Also, to click in A3 and select Window|Freeze panes so that the column headings and the column totals are always displayed no matter how far you scroll down.
The formula for Column C is:
(The maximum number of rows in a worksheet is 2^16 or 65,536.)