Intergrate data area in a function

[istratos]

Hallo

My problem:
I have decimal numbers in column A, extending from Cell A1 to cell A100


In Cell B1 I type the number 10
And
In cell B2 I type the number 50

What do I have to type in Cell C1 to calculate the maximum value from
area A10 to A50?
Please consider that 10 and 50 are the numbers I typed on cell B1 and
B2…

 

[Ardus Petus]

=MAX(INDIRECT("A"&B1&":A"&B2))

HTH
--
AP

"istratos" <[email protected]> a écrit
dans le message de
news:[email protected]...