I have a pivot table (attached) and need a formula that gives me the average Auto amount per country (based on # of people).
For example, in Spain there are 4 people with Auto. The average is actually $1,754 (total of 7,017 divided by 4 people). How can I get this from the data I have?
Bookmarks