The sum of the largest ten numerical values

Question

I have a Workbook and I want to extract the maximum sum of ten numerical values based on two conditions.

Answer 1

Hi,

I created a sample about your requirement:

=SUMPRODUCT(LARGE((A$2:A$71&B$2:B$71=E2&F2)*C$2:C$71,ROW($1:$10)))

Just checking in to see if the information was helpful. Please let us know if you would like further assistance.

---

If the response is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Some additional details might help us provide a more useful answer.

Are you looking for a macro or a formula? Do you want both conditions to be true, either, or only one? Have you looked at the IF and LARGE functions?

For sake of example, assume your data is in A1:A100.

• In an unused column (e.g., X), in cell X1 enter a formula to copy the value in A1 if the conditions are satisfied and 0 other wise.
• Copy this formula to X2:X100
• In any spare 10 cells, enter formulas to extract each of the 10 largest values in X1:X100
• In the cell to contain the requested sum, enter the formula to sum these 10 cells.