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