Auto sum returns a 0 value in place of sum of values in column

Auto sum returns a 0 value in place of sum of values in column

Post by Sm8gQW5uY » Wed, 30 Aug 2006 01:54:01


The data was entered as numbers. My document has 7 columns each formatted
the same; however when I use the auto sum 2 columns show a 0 value. I have
tried both copying the formula and typing the formula with the same result. I
can get a calculation using multiple plus signs & entering each row/cell so
the number formatting doesn in error.
--
Jo Anna
 
 
 

Auto sum returns a 0 value in place of sum of values in column

Post by Dave Peter » Wed, 30 Aug 2006 02:56:34

Formatting the cells as a number isn't enough to change the value in each of the
cells.

You have a formula like =sum(a1:a10) right?

Try this formula in an empty cell: =count(a1:a10)

This will return the number of cells that are actually numbers. Then try the
technique that Gord suggested. Watch what happens to your =sum() formula and
the =count() formula.





--

Dave Peterson