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

So I've got a spreadsheet with around 5 different rows, each one with a specific value (specifically a range of cells E2 - E8) and a "Total: " cell at the bottom, whose formula is this:


But when I enter the values, the Total: cell displays "###" as a result and anything that relies on the "total: " value does the same. I can't seem to figure out why. Could anyone shed some light on the problem? As far as I can tell there's nothing wrong with the formula, and the formatting of the numbers doesn't look wrong to me either.

share|improve this question
up vote 3 down vote accepted

Are you sure it's exactly "###" value in this cell? Usually "###" is the way spreadsheets display a value, which does not fit a column's width (and a value is OK itself; it's just not displayed). Try to widen a column a bit... :)

share|improve this answer
WOO that fixed it. Thanks a bunch dude. I feel silly, though, didn't think to make the column wider, since it doesn't have a problem displaying text that's too big for the cell, it just marks the sides with red arrows. – cornjuliox Sep 20 '12 at 18:54

You must log in to answer this question.

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