Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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:

=Sum(E2:E8)

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
add comment

1 Answer 1

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
add comment

Your Answer

 
discard

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.