I am trying to do the SUM function in the yellow cell, to see if the total amount (cell in blue) is correct.
But it's a dynamic rows, eg, sometimes 5 row, sometimes 15 row, etc
And is there any way do it in "Relative references" instead of the fixed column B, Column C, etc.
if it is possible that when I select the yellow cell, and then run Marco to insert a Sum function that [=SUM(B2:B13,-B14)] with relative reference] in yellow cell.
Attached is the excel sheet for reference.