Need to add a row in excel file with specifications

I have to look for the contract in question (knowing that it is dynamic and that the cells are merged) for example: 0331027790 and when I find it I have to add just below its cell a line in which I will sum each column relating to the contract from column F.
For example: H11= sum (from H7 to H10)
I11 = sum (from I7 to I10) and so on.

How to proceed please?