Excel tutorials

Sometimes we have a need to sum certain numbers in a range, here we are going to look at how we can sum the largest 3.

First we need to find the largest number, we have a function for this, LARGE.

Below in G6 we have the following formula:

=LARGE(D7:D11;1)

The formula looks in the given range, and takes the largest, if we supply number 2, we get the second largest and so on.

Now, to sum the largest 3, we will include the SUM function.

In G15 we have the following:

=SUM(LARGE(D7:D11;{1;2;3}))

We just replace number 1 above with {1;2;3}

This is then used as an argument to the SUM function