[SOLVED]How to change a formula across multiple colums and rows

Hi all

I have an issue on my sheet, my formula reads data from a list of contracts, my problem is whoever created it has only given me 42 lines and i need more.

each formula references the table multiple times. i am on week 42 at the moment and have 10 weeks still to go, is there an easy way to change these from

IF($H46="fixed",1,0)*(SUMIF($C$8:$C$42,$G46,Q$8:Q$42)*(I46+J46))

=IF($H46="fixed",1,0)*SUMIF($C$8:$C$42,$G46,M$8:M$42)*P46

to

IF($H46="fixed",1,0)*(SUMIF($C$8:$C$43,$G46,Q$8:Q$43)*(I46+J46))

=IF($H46="fixed",1,0)*SUMIF($C$8:$C$43,$G46,M$8:M$43)*P46

or can i make it dynamic if a new contract is added is added.

hope this is clear