I have an excel file where the data is in the following format.
account ID, name of business, country (including empty cells where country info is missing), monthly revenue, url of the account.
I need to find the total monthly revenue for all the accounts in each country. There are about 100 countries there and more than 6000 accounts and so it is not easy or quick to do it manually.
How do I do this?
I am using a MAC by the way. I would also like to be able to do this in Google docs / spreadsheet.