Summarise a spreadsheet

Hi and welcome to the board
There are various ways to solve this, one of them being a Pivot Table.
Select a cell in your list Click data - Pivot Tables and follow the wizard

HTH

thanks arthur, i'll give it a bash