Hacker News new | ask | show | jobs
by thih9 1166 days ago
If I add a row at the end saying “another | $1000”, the total doesn’t get updated (the SUM still points to B2-B6, so doesn’t include the new field). Is that intentional?
1 comments
diarmuid_glynn 1166 days ago
Yes, that's intentional. Assuming “another | $1000” is on the 7th row, you would need to update the formula to:

    =SUM(B2:B7)
to incorporate it into the sum.
link