NUMBERS help please

[Madwolfie]

Hi
I am struggling to get this to work how I want it to - anyone any ideas?

I have 2 columns, A has prices of sold items in it, B has the date (just the year). I am trying to provide a result where I can get a SUM of the year using column A, but referencing which year from column B.

Result: ideally, woud be separate totals for each year, of all that has been sold, of all the prices in column A

Thanks in advance

 

[Lufbrarunner]

This Video I made may point you in the right direction

Click on Organise.
From the dropdown menu on Add a category select Date (or whatever your heading is)

select a blank cell next to one of the years and choose sub Total

you can toggle the Categories swith to change from table view to category viwe.