[diarmuid_glynn]

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.