need formula help

J

jschott

I am trying to set up a spreadsheet that will add 15 numbers in
column. Sounds simple right! The trick is I actually only want to ad
12 of those numbers. Is it possible to set a formula that will add u
the 12 largest numbers in the column. Keeping in mind the 12 larges
numbers will vary which row they appear in in each column. It seem
like this should be a possiblity but I can't seem to figure it ou...Ca
anyone else??
 
D

Dan E

Jschott,

You can use the LARGE formula in combination with the SUM formula

=SUM(LARGE(A1:A15;{1,2,3,4,5,6,7,8,9,10,11,12}))

Dan E
 
D

Don Guillett

try this. It must be ARRAY entered or edited with control+Shift+enter

=SUM(LARGE(D1:D100,ROW(1:12)))
 
P

Peo Sjoblom

=SUMPRODUCT(LARGE(A1:A15,ROW(INDIRECT("1:12"))))

or

=SUM(A1:A15)-SUM(SMALL(A1:A15,{1,2,3}))

the latter entered with ctrl + shift & enter
 
D

Dan E

Peo Sjoblom said:
=SUMPRODUCT(LARGE(A1:A15,ROW(INDIRECT("1:12"))))

or

=SUM(A1:A15)-SUM(SMALL(A1:A15,{1,2,3}))

the latter entered with ctrl + shift & enter
Click to expand...

Your second formula doesn't need to be array entered...

Dan E
 
Top