Sum of two highest numbers

J

Jonny B

Hi all,

Thanks in advance for being there and helping. I'm Ok with the basics o
Excel, and indeed some years ago got quite good with bits of it, but a
struggling with something at home now, as I have no manual, and
haven't needed Excel for some time so I feel like a beginner again.
can't even find a manual online, and I thought surely that MS would hav
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 o
taking the two highest amounts, whichever column they may be in, an
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 o
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 o
a "compare" function, but that may not have been Excel..

Thanks if anyone can help.

Jon B
 
M

Mazzaropi

Jonny said:
Hi all,
Thanks in advance for being there and helping. I'm Ok with the basics o
Excel, and indeed some years ago got quite good with bits of it, but a
struggling with something at home now, as I have no manual, and
haven't needed Excel for some time so I feel like a beginner again.
can't even find a manual online, and I thought surely that MS would hav
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 o
taking the two highest amounts, whichever column they may be in, an
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 o
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 o
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[/B] --> =LARGE(A1:C1,1)+LARGE(A1:C1,2

Tell us if it worked for you
 
C

Claus Busch

Hi Jonny,

Am Sat, 23 Feb 2013 14:48:19 +0000 schrieb Jonny B:
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.

if you only have 3 columns you can use:
=SUM(A1:C1)-MIN(A1:C1)
If you have 4 columns:
=MAX(A1:D1)+LARGE(A1:D1,2)


Regards
Claus Busch
 
J

Jonny B

Jonny said:
Muito obrigado, Mazzaropi.

I will try later and will contact you.

Regards,

Jon

Perfect, mazzaropi. Thank you for such a quick reply.

Hope to contact again one day.

Best wishes from England.

Jo
 
M

Mazzaropi

Jonny said:
Perfect, mazzaropi. Thank you for such a quick reply.
Hope to contact again one day.
Best wishes from England.
Jon

I feel glad to help you.
Best wishes from Brazi
 
S

Stan Brown

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!

<rant>
One would think, but if it exists I've been unable to find it.
Whatever one may think of the features, the help system in Excel
seems to get more and more frustrating in every release. I can
understand why people go and buy books to figure out how to use the
damn thing.
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.

The LARGE function is what you want.

Your example makes no sense without your file (and 18+22=40, not 30),
and attachments don't work in a text newsgroup like this one, but let
me give you a simple example.

Suppose that A1:C42 contain your numbers. Put this formula in cell
D1:

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

and then click and drag down to fill D2 through D42.
 
C

Claus Busch

hi Jonny,

Am Sat, 23 Feb 2013 20:53:32 +0100 schrieb Claus Busch:
if you only have 3 columns you can use:
=SUM(A1:C1)-MIN(A1:C1)
If you have 4 columns:
=MAX(A1:D1)+LARGE(A1:D1,2)

another way:
=SUM(LARGE(A1:D1,{1,2}))


Regards
Claus Busch
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top