Yvonne Love
Member
I haven't been able to find an answer to that, but admittedly I may not be describing it correctly. And I feel like it should be a really obvious, easy answer that I am just overlooking.
I have a dummy spreadsheet attached showing a column for Company, Region, and Fees. Each client has more than one row, so using averageifs based on Region is not pulling the correct average if needing the average per company per region. The average should be the total fees for each company in each region divided by the # of companies in each region.
I assume some kind of array formula (or even something far easier) should be able to accomplish this, but I just can't find that formula. Am I overlooking something very simple? And if not, is there an array formula that will give me total fees for each company in a region (when a company has multiple rows) divided by unique companies in that region?
I've attached a dummy data spreadsheet for reference.
Thanks!
YL
I have a dummy spreadsheet attached showing a column for Company, Region, and Fees. Each client has more than one row, so using averageifs based on Region is not pulling the correct average if needing the average per company per region. The average should be the total fees for each company in each region divided by the # of companies in each region.
I assume some kind of array formula (or even something far easier) should be able to accomplish this, but I just can't find that formula. Am I overlooking something very simple? And if not, is there an array formula that will give me total fees for each company in a region (when a company has multiple rows) divided by unique companies in that region?
I've attached a dummy data spreadsheet for reference.
Thanks!
YL