The MAXimum of the sum of two sets of numbers.

[Darren Bartrup]

Hi all,

This seems like it should be easy, but I just can't get my head around it.

Basically I want to find the maximum of each row added together.
i.e.

=MAX(SUM(E7:E8),SUM(F7:F8),SUM(G7:G8),SUM(H7:H8),SUM(I7:I8))

which gives a result of 146.8.

Is there an easier way to write this using an array formula?
There will be between 1 and 30 sets of numbers depending on choices made elsewhere within the workbook.

SAS 2008 IV.xls
	E	F	G	H	I
7	75.5	81.5	82	82.5	83
8	52	65.3	55	57.1	63.8
Raw Data (Sorted)

Someone please help. My brain seems to have stopped working this week.

Regards,
Darren.

 

[barry houdini]

Try

=MAX(E7:I7+E8:I8)

confirmed with CTRL+SHIFT+ENTER

 

[Darren Bartrup]

Thanks for that Barry,

Unfortunately it's giving me a result of 158.5 which doesn't seem to be the sum of any of the numbers.

The Evaluate Formula dialog tells me it's doing this:

MAX({158,5;115,8})

and I've no idea where those numbers are coming from.

regards,
Darren.

 

[barry houdini]

MAX({158,5;115,8})

That looks like you've used a 2x2 range, did you use the exact formula I posted or a variation?