Google Sheets question: Sum up orders per country

supermex

Elite Member
Joined
Nov 19, 2016
Messages
1,825
Reaction score
658
Hi guys,

Quick question about google sheets. I have a table were all of my customer's orders are saved. 1 order per row.

Now I want to create a diagram that shows the total sales revenue of all orders per country.

So it's like:

USA: 524645764357€
CHINA: 426546246€
FRANCE: 4256245€
etc....


How can I do this? I already managed to create a diagram for the amount of orders per country, but I don't get how to show the total revenue of the orders per country.

Any ideas? Here's how the table looks like:
Bildschirmfoto 2019-01-21 um 14.24.10.png
 
Back
Top