I need help.

New Contributor

Hello everyone.


Maybe this question has been answered before and I'm practicing a lot about Excel these days.


Here is my request.


I have an excel table with a sum factor. I would like that each time I add a line before the red line, the red line takes into account the line that I just added in the sum. I hope you will understand my request and that you can answer it. Attached is a capture. Cordially



3 Replies


Your link results in Access Denied.


In E15:


Fill to the right.

Always insert new lines in the row above the red row, not in the red row itself. The formulas will then be adjusted correctly.