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
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2