On 4 Nov, 11:41, Aqib Rizvi wrote:
Keep the last row blank. Always include that in your sum formula. If
you insert/delete rows above the blank row, the formula will adjust
itself to included added/deleted rows.
AQIB RIZVI

Thanks for your feedback AQIB. See the post by JP for a different
solution.