Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Possible Duplicate:
Can you reference an entire column in OpenOffice Calc (like A:A in Excel)?

I'm using a Sum of a column, and it keeps growing, so I have to update the reference to which cells should be summed.
Can you reference an infinite group of cells?
Let's say:

No matter if you use LibreOffice, Excel or any other spreadsheet, your solution may be applied to LibreOffice too.

share|improve this question

marked as duplicate by Daniel Beck, Sathya Oct 22 '11 at 11:28

This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.

up vote 2 down vote accepted

In Excel the solution is to use a reference to the entire column. While Excel has a limit on the number of rows and columns a sheet can have, the maximum number is as close to infinite as you're going to get.

For your example, you could use the following:


This adds everything in Column D and subtracts the value of D1, the cell you left out.

share|improve this answer

Not the answer you're looking for? Browse other questions tagged .