View Single Post
  #2   Report Post  
Mazzaropi Mazzaropi is offline
Senior Member
 
Location: Belo Horizonte, Brazil
Posts: 170
Thumbs up

Quote:
Originally Posted by Jonny B View Post
Hi all,
Thanks in advance for being there and helping. I'm Ok with the basics of Excel, and indeed some years ago got quite good with bits of it, but am struggling with something at home now, as I have no manual, and I haven't needed Excel for some time so I feel like a beginner again. I can't even find a manual online, and I thought surely that MS would have a helping copy of the manual somewhere!
Anyway, if anyone could guide me I'd be very grateful.
I have three or four columns of figures, and need to find a way of taking the two highest amounts, whichever column they may be in, and adding them together, with the sum displayed in a fourth column.
So, for example, in the first line 15, 18 and 22 would give me a sum of 30
and in the second line 21, 20 and 12 would give me 41, etc.
Is there a simple formula to do this, please. I have vague memories of a "compare" function, but that may not have been Excel..
Thanks if anyone can help.
Jon B.
Help from Brazil.

Good Morning Jon B.

Supposing your data at columns A,B and C, try to do this:

D1 -- =LARGE(A1:C1,1)+LARGE(A1:C1,2)

Tell us if it worked for you.
__________________
I hope it can help you.

Best regards,
Marcilio Lobão
---------------------------
Belo Horizonte, Brazil