Jaymond Flurrie
Well-known Member
- Joined
- Sep 22, 2008
- Messages
- 927
- Office Version
- 365
- Platform
- Windows
1 | 2 |
2 | 1 |
3 | 1 |
1 | 3 |
1 | 1 |
1 | 1 |
5 | 1 |
1 | 2 |
Trying to find the sum of the max row. That is the values are 1+2=3, 2+1=3, 4, 4, 2, 2, 6 and 3 and the result is then 6.
I think I need an array formula. I tried like: {=MAX(SUM(A1:A8;B1:B8))}
but that's not correct.