3 ms·
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 int
by thih9 4y 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?
- diarmuid_glynn 4y agoYes, 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.