Trouble with Formulas

❓ Questions & help 𝑓x Formulas
1

Hi folks I am adding several formuals to my work sheet and i need them to proigate down as new sheets are added the problem is it works on the row I am cooding and then it does not move down when i open a new row.

I have tried to copy past it and add an extra 100 rows to the sheet be the problem here is when i open a new row it will start at 101 aging the formulas are not been pulled through

Can any body point me in the right direction

2

Hi Kevin,

If you want a formula to populate in the column, use the column type Formula. This will propagate starting in the row you indicate.

Here is one that I use for a running balance:
SUM(E,OFFSET(I,-1,0))

3 Likes
3

Tank so much I will use this