sum returning 0 result

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?!
 
M

Max

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 ..
 
B

Bob Phillips

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)
 
J

Jerry W. Lewis

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
 
D

Dave Peterson

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.
 
C

ClaudCar

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.
 
H

Harlan Grove

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.
 
D

Dave Peterson

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...
 
Top