You already have two replies, but I read your request differently -
you want to add the maximum from 5 columns (assume A:E) and the
maximum from four other columns (assume G:J). If so, try this:

=MAX(A1:E1000)+MAX(G1:J1000)

Adjust the ranges to suit.

Hope this helps.

Pete

On May 18, 7:00 am, Arshad wrote:
I need to get sum of two maximum figures from five and four columns. Please
give me the formula in Excel Sheet.

Thanks.

Arshad