sum returning 0 result

  • Thread starter Thread starter ClaudCar
  • Start date Start date
C

ClaudCar

totalling up a bunch of non-contiguous, but columnar cells. cells contain
totals of the cells above them. the final total is returning a zero result.
What am I missing here - against my deadline?!
 
Pehaps calc mode is accidentally set to manual ?

Try pressing F9, does it now compute properly?

To quickly check / change the calc mode:
Click Tools > Options > Calculation tab
Ensure "Automatic" is checked > OK

If the above isn't it, post the final total formula
and maybe a sample of the other ones as well ..
 
Another option is that the cells are formatted as text, and so they may look
like numbers but treated as strings.

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
You can test this hypothesis by changing the SUM() function to COUNT(),
if it still returns zero, then the cells are text, not numbers.

Jerry
 
And a quick way to convert those text numbers to number numbers is to copy an
empty cell, then select the offending range and do:

edit|paste special|and click the Add button.
 
THANK YOU ALL! I had opened it in a different version of Excel that didn't
have numbers as the default format. Now I can stop tearing my hair out at
such an easy solution.
 
Dave Peterson wrote...
And a quick way to convert those text numbers to number numbers is to copy an
empty cell, then select the offending range and do:

edit|paste special|and click the Add button.
Click to expand...
....

Unless those cells have numeric format Text, it'd be even quicker to
select the range and run Data > Text to Columns, select Fixed Width and
immediately click Finish in the first dialog of the text conversion
wizard.
 
The race is on!
<vbg>



Harlan said:
Dave Peterson wrote...
...

Unless those cells have numeric format Text, it'd be even quicker to
select the range and run Data > Text to Columns, select Fixed Width and
immediately click Finish in the first dialog of the text conversion
wizard.
Click to expand...
 
Back
Top