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

In Libreoffice Calc, sometimes the SUM function returns ### in the cell when referencing other sums. For example:

=SUM(x1+y1)

where

x1=sum(a1:d1)
y1=sum(a2:d2)

gives

###

in the output cell. (obviously this is not my real data)

Sometimes the function outputs correctly if I re-make it. It also tends to error like this when I change the values of the referenced cells.

Any ideas?

share|improve this question
up vote 0 down vote accepted

Make the column wider. The number is too big to fit.

share|improve this answer
    
Boy, don't I feel stupid. :/ Thanks for the solve! – osti_non Jan 29 '13 at 20:32
    
NP. Glad I could help. – Nicole Hamilton Jan 29 '13 at 20:33

You must log in to answer this question.

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