johannaexcel
New Member
- Joined
- Mar 23, 2021
- Messages
- 1
- Office Version
- 365
- Platform
- Windows
I am trying to create a top 10 summed value list with a criteria (in cell G1), but my formula is not working. I used this formula:
=INDEX(SORT(CHOOSE({1;2};UNIQUE(FILTER(A2:A12;B2:B12=H1));SUMIFS(C2:C12;B2:B12;H1;A2:A12;UNIQUE(FILTER(A2:A12;B2:B12=H1))));2;-1);SEQUENCE(10;2);{1;2})
I would like to be able to come up with the Top 10 Sales person after adding up the values for each sales in Dallas. Can you help me how to create a summed value list? Thank you.
=INDEX(SORT(CHOOSE({1;2};UNIQUE(FILTER(A2:A12;B2:B12=H1));SUMIFS(C2:C12;B2:B12;H1;A2:A12;UNIQUE(FILTER(A2:A12;B2:B12=H1))));2;-1);SEQUENCE(10;2);{1;2})
I would like to be able to come up with the Top 10 Sales person after adding up the values for each sales in Dallas. Can you help me how to create a summed value list? Thank you.