Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.