I need help.

[Polopich]

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

https://drive.google.com/file/d/18xy46IovmhH-7yeMFm2Bko45DFpQgdHk/view?usp=share_link

[#2]

@Polopich 

Your link results in Access Denied.

[#3]

hi, thank's for replying;

here's a new one.

thank's

https://drive.google.com/file/d/18xy46IovmhH-7yeMFm2Bko45DFpQgdHk/view?usp=share_link

[#4]

@Polopich 

In E15:

=SOMME(E4:E14)

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.