Or a nice and simple pivot table after making an Excel Table out of your range ( I added a dates field just in case)
To update, add rows - refresh - you're OK to go

Attached Files

Book2.xlsx (15.2 KB, 4 views)

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post