# The MAXimum of the sum of two sets of numbers.

#### Darren Bartrup

##### Well-known Member
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.
Code:
``=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
EFGHI
775.581.58282.583
85265.35557.163.8
Raw Data (Sorted)

Regards,
Darren.

### Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December

#### barry houdini

##### MrExcel MVP
Try

=MAX(E7:I7+E8:I8)

confirmed with CTRL+SHIFT+ENTER

#### Darren Bartrup

##### Well-known Member
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:
Code:
``MAX({158,5;115,8})``
and I've no idea where those numbers are coming from.

regards,
Darren.

#### barry houdini

##### MrExcel MVP
Code:
``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?

Replies
4
Views
168
Replies
3
Views
107
Replies
0
Views
156
Replies
5
Views
524
Replies
2
Views
166

1,191,633
Messages
5,987,787
Members
440,110
Latest member
albertod8

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back