Hi,
Referring to the uploaded file, I am trying to calculate the sum of the values in Column C (Value 2) based on the Top 10 values in Column B (Value 1).
I know the =SUM(LARGE(B2:B21,ROW(INDIRECT("1:10")))) function will retrieve the Sum of the Top 10 Values in Column B.
However, I am trying to Sum the values in Column C based on the corresponding Top 10 Values in Column B.
Manually, this would require me to sort Column B by largest to smallest and then sum the Top 10 values in Column C, resulting in an answer of 16.7
Referring to the uploaded file, I am trying to calculate the sum of the values in Column C (Value 2) based on the Top 10 values in Column B (Value 1).
I know the =SUM(LARGE(B2:B21,ROW(INDIRECT("1:10")))) function will retrieve the Sum of the Top 10 Values in Column B.
However, I am trying to Sum the values in Column C based on the corresponding Top 10 Values in Column B.
Manually, this would require me to sort Column B by largest to smallest and then sum the Top 10 values in Column C, resulting in an answer of 16.7