OpenOffice Calc: Finding max value

2
votes

Let's say that i have an array:

   |A  B  C  D
---------------
1  |2  8  6  3
2  |1  2  5  2

Where first row stand for "Goals Scored" and the second row for "Goals Lost". Columns stands for games/matches

I want to find the maximum total number of goals scored and lost in one match. In case above it would be 11 (C1 + C2).

I don't want to use

I spent few days trying functions like: MAX, ADDRESS, CELL, SUBTOTAL, SUM, MMULT, TRANSPOSE, etc. and even combined but i didn't get satisfying result.

2
openoffice-calc

2 Answers

0
votes

The MAX function have to work:

Returns the maximum of a list of arguments, ignoring text entries.

Example:

MAX(B1:B3)

where cells B1, B2, B3 contain 1.1, 2.2, and apple returns 2.2.
0
votes

Select cell A3 and set the formula to =A1+A2. Then click the square in the lower-right corner of the selected cell and drag to D3. This gives:

   |A  B  C  D
---------------
1  |2  8  6  3
2  |1  2  5  2
3  |3 10 11  5

Now =MAX(A3:D3) produces 11.