How to calculate values related to specific dates

I know I'm already asking for too much but can we include in the formula a function in which it will not include the amounts for totals under column K to V, because I need to extend those all the way down to V200, and whenever I do so, it is also summing up the amounts in the totals row.

See formulas in H5

=SUMIFS(STRAIGHTLINE!$D$6:$D$400,STRAIGHTLINE!$I$6:$I$400,">0",STRAIGHTLINE!$B$6:$B$400,"<>Totals")-SUMIFS(STRAIGHTLINE!$I$6:$I$400,STRAIGHTLINE!$B$6:$B$400,"<>Totals")+SUMPRODUCT((STRAIGHTLINE!$K$6:$K$400:INDEX(STRAIGHTLINE!$K$6:$V$400,,MATCH(SUMMARY!$E$2,STRAIGHTLINE!$K$4:$V$4,0)))*(STRAIGHTLINE!$B$6:$B$400<>"Totals"))

and H6

=SUMIFS(DIMINISHING!$D$6:$D$400,DIMINISHING!$I$6:$I$400,">0",DIMINISHING!$B$6:$B$400,"<>Totals")-SUMIFS(DIMINISHING!$I$6:$I$400,DIMINISHING!$B$6:$B$400,"<>Totals")+SUMPRODUCT((DIMINISHING!$K$6:$K$400:INDEX(DIMINISHING!$K$6:$V$400,,MATCH(SUMMARY!$E$2,DIMINISHING!$K$4:$V$4,0)))*(DIMINISHING!$B$6:$B$400<>"Totals"))

Formulas in Straightening need changing to replace "null" with 0

=IF(OR(K$4<=EOMONTH($E6,-1)+1,K$4>EOMONTH($E6+ROUNDUP($G6*365,1),-1)+1),0,IF(K$4=EOMONTH($E6,-1)+1,$D6*$H6*((((EOMONTH(K$4,0))-$E6+1))/365),IF(K$4=EOMONTH($E6+ROUNDUP($G6*365,1),-1)+1,$I6-SUM($J6:J6),$D6*$H6*(((EOMONTH(K$4,0))-((EOMONTH(K$4,-1)+1))+1)/365))))