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
Bookmarks