How to make the 'Total's' row automatically move down as & protect it from overwriting?

So, let say I am selling bottles with and without a cap and a capsule.

I have the amount from last month and I want workers to update my sheet every time they use/add one of the items. Sometimes many times a day for one item and not at all for another. There are so many items that it would be a hassle to use a sheet per item.

I want that the total sum cannot be over written and that they still can add rows as needed, as I don't know how many times they need the product. (If I estimate 5 times a day/ 30 days a month then the total is quite far away down)

So it would be ideal to start with the total sum on a row 23 or so, then if they could add rows (or even better, empty row will appear when something is typed on the row above!) and the total would jump one row down. And not be over written.

I'm sorry, I hope someone can understand my ramblings!

You could think about putting your totals on the top row (by inserting blank row(s) at the top of the sheet) and then you could have a formula in B1 like:

=SUM(B$3:B5000)

or you could make the range as long as you like. Using Freeze Panes on the top two rows would ensure that those totals will always be visible.

Hope this helps.

Pete

Thank you so much, I didn't think about that at all! If you don't mind, I wonder if you could help me with the date as well?

I had the =IF(B6="";"";NOW()) but now I see it changes the date for today. I tried different versions like DATE but it's not right... I would need the date when the B6 cell had the value added (something taken from the warehouse)