Creating a continuous total

Hi,

I'm trying to create a spreadsheet to act as a score card for a card game. I have put an screenshot below for reference:

f58ae619-9b7e-4b32-89ea-bcb42b1700c8_zps3ef3701d.jpg

At the bottom of the spreadsheet I have the total showing, however this is just for one game. At the beginning of the next game the main content will be deleted to start again. I would like these totals to remain, despite the deletion, and continue to add up with the new scores. So for example

D27 currently = 10. I want to be able to delete the contents of D7:D16, but I still want D27 to show 10 - without me having to type it in each time. I would then like it to add D17 to keep a constant running total.

Is this possible to achieve?

Thanks in advance,

Tom

Hi,

Thanks for that, I didn't realise that I could upload the actual file. I'll attach it now. Hope this works

Tom

Rummy scoresheet.xlsx

That's fantastic, thank you very much! Looks as though I need to learn how to create macros!

Tom