I need a formula that will sum the top 3 number in a column

H

havocdragon

Hey all. I can't think of anything that would let me do this, but lets say I
have a column (we will say column A) that contains numbers from row 1 to row
100. I would like to put a formula at the bottom of this tha will calculate
the top 3 numbers in this column and sum them together.
 
D

Domenic

If you have the following numbers...

10
8
12
10
6

....which result do you expect, 32 or 30?
 
J

Jack Sheet

How about
=LARGE(A1:A100,1)+LARGE(A1:A100,2)+LARGE(A1:A100,3)

Or more generally, suppose cell B1 countains a number that represents the
number of items to be summed (in this example 3), then

=SUM(LARGE(A1:A100,ROW(INDIRECT("1:"&B1))))
entered as an array formula (hold down control+shift then enter when
entering the formula)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sum of values in column A based on 0/1 of column B 2
Converting a number into a cell reference 2
Using =SUM...just can't figure this simple thing out... 2
How can the font and size of (all) citation numbers be altered? 1
Solution to tricky problem of showing exactly Top N rows in Pivottable 0
I need to place a rule between columns 0
VLOOKUP or SUMIF for Multiple Criteria 2
Display next available number 1

Top