How can I add a few highest numbers from a group of many numbers in Excel (e.g., suppose I have 74, 60, 59, 80, 71, 64, 90 in a row)?

Answer 1

Hello!

Please see the following options you could use.

Option1:

Assuming you have 74, 60, 59, 80, 71, 64, 90 in a row. First you enter them from A1 through A7. Then from the Home Tab, go to Sort & Filter. Click on "Sort Smallest to Largest". The numbers will sort like the function indicated. Then in cell A8, you can enter the sum function. The sum function is located in Home tab, then click on the ∑ sign, then select "Sum". From there you can select any numbers you want to add and hit Enter. Cell A8 should display the desired result.

Option2:

Another way to do this (requires more time):

Once you sort the number, write the following in cell A8 to add all the numbers (note: you can select whichever numbers you wish to add):

=A1+A2+A3+A4+A5+A6+A7 Enter

I would recommend going with option 1. It seems like a lot of steps but it is fairly easy. Hope that helps!