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 (EDIT that should be 40 - sorry!)

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.