Adding up the latest 5 number automatically

Hi,

I have a spreadsheet needed to be updated everyday, and I also need to add up the past 5 days number as well.

Instead of using =sum formula everyday, is there any way I can use the formula to add up the latest 5 numbers (which automatically pick up the new number and don't add up the oldest number), it could save my time everyday.

Please find the attachment for the example.

Thanks

Most of the time there will be 5 numbers to sum.

But if there has not enough 5 number, say 4 or 3, then just sum up those numbers

Thanks

Thanks Tony,

Very helpful