LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 347
Default sum of my formula is 0

Hi,

Hit the F9 key to see what happens. Then check Tools/Options/Calculation and
see if calculation is set to "manual" or "Automatic".

HTH
Jean-Guy



"Michelle" wrote:

I am entering a formula in a cell. (same as I have 100 times)
=SUM(F8+F15+F18+F25+F29+F31)
It keeps coming up 0.
I have tried deleting and reentering by clicking on the cells
I have tried deleting and reentering one cell at a time
I have checked to make sure all the cells are numbers with 2 decimal points.
This happened in another document recently.
Anybody know what the problem is?

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 07:21 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"