In a function use range from specific row to end of column

[theboeh]

So I would like to get the sum of a column minus the first four cells in the column. What I’m doing now is =SUM(A4:A3000). The issue with that is that when I hit cell 3000 I have to alter that function. What I would like to do is something more like =SUM(A4:A<end of column>). Equally I would accept a way to to say A:A omitting A1:A4.

Thanks in advance!

[ROSt53]

I cannot say what you make wrong but if you data are in column A from cell A1 to A3000 the forumla

=sum(A5:A300)

should work. You want the first 4 cells excluded, thus need to start in the 5th row.

I made a test with data in column C; Here is a screen shot of the important part

LibO 4.0.4 on XP