Sum Columns and Copy highest value

[t111kav]

Hi,

I have a range of data in columns A:E.

I need to sum the total of columns B, C, and E (separately) and take the highest value and copy this into cell "I42" - then remove the cells containing the sum totals.

Any help would be great

Thanks in advance

Tim

 

[Special-K99]

in I42
=MAX(B:B,C:C,E:E)

No need to remove sum total cells since the above is a formula.
Performing a B:B is not advisable something like B1:B1000 would be better, so limit the range if you can

 

[t111kav]

that works for highest individual value but i think i confused that by saying highest value, it should be the highest column total. Sorry my fault..

so i need to take the column totals for B, C, E and whichever is the highest put into cell I42

thanks