Ask Your Question
0

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

asked 2013-07-21 19:53:55 +0100

theboeh gravatar image

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!

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2015-11-04 02:29:17.769456

1 Answer

Sort by » oldest newest most voted
0

answered 2013-07-22 09:27:03 +0100

ROSt52 gravatar image

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

image description

LibO 4.0.4 on XP

edit flag offensive delete link more

Question Tools

1 follower

Stats

Asked: 2013-07-21 19:53:55 +0100

Seen: 443 times

Last updated: Jul 22 '13