Because you haven't given it enough room to display the result. Widen the
column, or use a smaller font.

Regards,
Fred

"Lindsey-Star" wrote in message
...
In cell I25 I have the following formula: =SUM(I11:I14)
All it displays is #####, but when I hover over it, it gives me the
correct
answer on a popup tip-like window which is $3,400. So, if it knows the
answer, why is it displaying with the pound signs instead? I think I've
tried everything.