smuralisankar
asked on
excel autosum for filtered results
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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
We don't have month as a field. These are people who are paying for a monthly subscription for SAAS product. So, we just have CMRR (monthly revenue).
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks.
I would also like to know how to do this using another method (maybe use a formula).
I would also like to know how to do this using another method (maybe use a formula).
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER