Set SUM range based on a cell content...

[pampo]

Hello guys,

I simple question for you, I hope, but a subtle issue for me, newbie of Calc.

What I want to do is get the SUM of a range of cells, but with the last cell not fixed,
but determined from the content of another cell, I mean, instead of

SUM(A1:A20)

I would like to put 20 or A20 in another cell and use it to determined the range.

The problem arises because I have a doc with multiple sheets where formulas
are the same, but data vary in size, so when I import data in a new sheet I simply
change the content of one cell, instead of changing all formulas.

Many thanks,

Matteo.

[8daysaweek.co.uk]

Hi Matteo,

Assuming the row number is in cell B21:
=SUM(INDIRECT("A1:A" & B21))

HTH ,
_________________
James
www.8daysaweek.co.uk - A User-Focused OOo site

[pampo]

Many many thanks, James!