Inserting a row that will make formulas follow

Hi,

I have an Excel Worksheet of which I made a simple demo of it here. ExcelForum.xlsx.

I'll use the Excel Worksheet I attached as a demo to guide you through my problem.

There is three rows. 1,2,3. In the first cell of the row, we have the row number.
The second cell contains a value (which is normally determined by multiple if statements).
The third cell contains another value like the cell to his left (again, determined by if statements in the real Worksheet).
The fourth cell is to be checked if the row is assign to the column a.
The fifth cell is to be checked if the the row is assign to the column b.
The seventh cell is to get the total of each rows.
The eigth cell is to determine if the row is assigned to a (if the column a is checked).
The ninth cell is to determine if the row is assigned to b (if the column b is checked).
In the row "total", we have the total of the column a and b (Sums) which comes from the same row but from the seventh and the eigth column. There is also an if statement to get the total of all the values in the seventh cell ( the total of each rows) crosschecked by the total of the columns a and b.

Question : How do I instert a row to this table and that this row as the same formulas every rows has ? In other words, how do I insert a row that does not affect the already in place formulas but also get's the same formulas for it's own row number ?

Thanks,
OUO

Alright, since that works, I'll get the person to do that instead. Thanks oeldere.

Thanks to you too ChemistB, I tried your solution but the formulas weren't following. (Can see it here :ExcelForum2.xlsx)

Your solution works too ChemistB with a simple click with the mouse. Thanks.

Both solutions works.

1-Oeldere : Insert a line. Copy the upper line, Paste it into the new line and change the data.
2-ChemistB : Convert your data into a table. Right-click the cell you want, Insert -> Row. Formulas followed.

Thanks to both of you, future readers will be able to choose the one that fits their needs best.