NUMBERS help please


Joined
Oct 22, 2020
Messages
1
Reaction score
0
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
 
Ad

Advertisements

Joined
Jan 25, 2017
Messages
761
Reaction score
43
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top