# Functions As SUM() Parameters/Arguments? [closed]

I can't count the number of times I've tried to figure this out. Search? I've searched and searched and searched. Finally I must ask.

LibréOffice version is inconsequential. I've had this problem with every version I've ever used.

Given a column you wish to sum(), where rows may be added, why does this not work:

=SUM(D3:ADDRESS(ROW()-1,4,3,1))

If I put

=ADDRESS(ROW()-1,4,3,1)

into, say, cell D35, I'll get "D34". So why does my SUM(), above, not give me the result of =SUM(D3:D34)? Instead I get "Err:502," "Invalid Argument." What am I, or LibréOffice Calc, doing wrong?

Thanks, Jim