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

Thanks Peco

This worked perfectly!! Not sure why I didn't think of this. It never crossed my mind that I could do a pivot table to solve this quick and easy....