function vs formula

[Linda B]

I am trying to find the sum of several factors and cannot
figure out the best way to accomplish this. I want to
add the amount in one cell with the sum of the 2 greatest
numbers in a group of cells. Can anyone help?

 

[Bob Umlas]

=D5+SUM(LARGE(E1:E100,{1,2}))
(note the curly braces around 1,2)
Bob Umlas
Excel MVP

 

[Frank Kabel]

Hi
try
=A1+LARGE(B1:B100,{1,2})

 

[JE McGimpsey]

One way:

=SUM(A1,LARGE(B1:B100,{1,2}))

 

[Trevor Shuttleworth]

Linda,

not sure if I've interpreted this correctly:

=F8+MAX(H8:H12)+MAX(J8:J14)

or alternatively:

=F8+LARGE(H8:H12:J8:J14,1)+LARGE(H8:H12:J8:J14,2)

Regards

Trevor

 

[Trevor Shuttleworth]

Just to revise my last response in the light of JE's posting ...

=F8+SUM(LARGE(H8:H12:J8:J14,{1,2}))

I'd forgotten the "sum" but this looks much neater but retains the separate
ranges

Regards

Trevor

 

[Ken Wright]

Hi Frank - You'll need the SUM function wrapped around your LARGE(), else you'll
only get the LARGE(xx,1) from it.

 

[Michael]

Hi Linda B
Assuming your fisrt Cell is A1 and your group of cells is
A4:A20.
Use the following:

=SUM(LARGE(A4:A20,{1,2}))+A1
Regards
Michael

 

[Frank Kabel]

Hi Ken
thanks for that (it's getting late I suppose). So make this
A1+SUM(LARGEB1:B100,{1,2}))

 

[Ken Wright]

(it's getting late I suppose).

Yup - The witching hour approacheth in the UK, and tis off to bed I must fly

 

[Linda B]

Thank you all so very much for your help! Our help desk couldn't figure this one out - but you guys are the greatest!!!