Running total in Excel Table

[HakanB]

I have created personal accounting using Excel Table. I have run into troubles when I need to create running total for different columns: The columns are bank accounts, which have an opening balance per Jan-1-2025. The opening balance is the problem to be included into the formula as it is a constant. I have tried with the formula IF(ROW()=2, OpenBal, [@Summa] + INDEX([Balance], ROW()-1), where OpenBal is the constant Open Balance, @Summa is the amount to add to the balance and Balance is the Balance column where the function is used. However this does not seem to autoexpand. Has anybody a better solution?

HakanB

 

[Peter_SSs]

Welcome to the MrExcel board!

Could you give us a small set of dummy sample data, with the expected results manually filled in and explain again in relation to the given sample data?
The best way to give us the sample data is with XL2BB
(If you have trouble with XL2BB, review the "XL2BB Icons greyed out" link in the 'Known XL2BB issues' section near the top of the XL2BB Instructions page linked above.)

 

[HakanB]

It is not the first time, after I put a question to a forum, that I actually find the solution myself. I started by entering data and formulas into a range and after that changed it to a table. In fact the used formula works in the table. The problem was that I created the table from a range filled with data and formulas. When I started over from scratch with an empty table the index(....) formula calculated correctly and auto-expand as well. The only thing disappointing me is that the validation rules won't be included in the auto-expand. Right?