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

 

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

3 Replies

@Polopich 

Your link results in Access Denied.

@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.