need formula help

[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??

 

[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

 

[Don Guillett]

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

=SUM(LARGE(D1100,ROW(1:12)))

 

[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

 

[Dan E]

=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

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

Dan E

 

[Peo Sjoblom]

Correct..

--

Regards,

Peo Sjoblom

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

Dan E