Hi all! I'm basically at a breaking point. I am trying to rank a file with sales by customer but the sales are broken out by a sub segment. I need to rank them at the total customer level. Below is a makeshift example of how my data looks (the rank column is the result I want):
<tbody>
</tbody>
What I'm looking for is to combine the total sales which I got with sumproduct (or sumif) and the rank into one formula.
Thanks much in advance!
Name | Sales | Total Sales | Rank |
A | 5 | 227 | 3 |
B | 85 | 85 | 4 |
C | 84 | 803 | 1 |
D | 635 | 648 | 2 |
A | 65 | 227 | 3 |
C | 645 | 803 | 1 |
A | 89 | 227 | 3 |
C | 74 | 803 | 1 |
D | 13 | 648 | 2 |
A | 68 | 227 | 3 |
<tbody>
</tbody>
What I'm looking for is to combine the total sales which I got with sumproduct (or sumif) and the rank into one formula.
Thanks much in advance!