How to calculate values related to specific dates

Originally Posted by JohnTopley

These give the results in your posted file:

=SUMIF(STRAIGHTLINE!$I$6:$I$8,">0",STRAIGHTLINE!$D$6:$D$8)-SUM(STRAIGHTLINE!$I$6:$I$8)+SUM(STRAIGHTLINE!$K$6:$K$8:INDEX(STRAIGHTLINE!K6:V8,,MATCH(SUMMARY!$E$2,STRAIGHTLINE!$K$4:$V$4,0)))

=SUMIF(DIMINISHING!$I$6:$I$8,">0",DIMINISHING!$D$6:$D$8)-SUM(DIMINISHING!$I$6:$I$8)+SUM(DIMINISHING!$K$6:$K$8:INDEX(DIMINISHING!$K$6:$V$8,,MATCH(SUMMARY!$E$2,DIMINISHING!$K$4:$V$4,0)))


EDIT: second formula corrected.

Hi, it's returning a #N/A value in me, see attached.