sum a named rage except the last row

[alexandruc]

Hello,

I have a range of cells named "one" (for example A1:A5 but the length is variable).

How can I add all values in the range except the last one?

The named range is a column (A) with a variable number of rows, and the last row of the named range "one" is the sum of the range. In order to avoid the circular reference I have to sum all values in the range without the last row... something like:

=SUM(one - last_row)

How can I make the SUM of the range without last row in the range?