function vs formula

  • Thread starter Thread starter Linda B
  • Start date Start date
L

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?
 
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
 
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
 
Hi Frank - You'll need the SUM function wrapped around your LARGE(), else you'll
only get the LARGE(xx,1) from it.
 
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
 
Hi Ken
thanks for that (it's getting late I suppose). So make this
A1+SUM(LARGEB1:B100,{1,2}))
 
(it's getting late I suppose).

Yup - The witching hour approacheth in the UK, and tis off to bed I must fly :-)
 
Thank you all so very much for your help! Our help desk couldn't figure this one out - but you guys are the greatest!!!
 
Back
Top