Sum the total of greatest Number in a Row from many Columns

[sudipto3003]

In Column "A" I have the name of the months from Jan13 to Dec13, in next three columns "B, C & D " I have the data against each months. Now I need the total value of those numbers from against every month which is the higher. For example please go through the following link....................


https://www.dropbox.com/s/h9tcpq0s0iltuxy/SAMPLE.xlsx?m

 

[Hui]

Sudipta


Try: =SUMPRODUCT(SUBTOTAL(4,OFFSET(B1:D1,ROW(A2:A13)-ROW(A1),)))


Or see here: https://www.dropbox.com/s/hxo7xrmt5n5144z/Sudipta%20Sample.xlsx?m


Please also refrain from typing the entire post in CAPITALS.