Sum with variable rows [closed]
Hi there, i need you help. I have for example:
Row 1: 8 Row 2: 90 Row 3: 98 | Total
So, in this case i need to do SUM(A1:A2), but if i add a row between the 3 and the 2, this values won't change, so the total, will include only the row 1 + row 2, but need it to include the new row that has been crested between the 2 and the 3, so variable cells.
Thanks for the time,
Best Regards, JM
Can you please describe the exact procedure: how do you insert the row (see my comment to the answer below)?