Adding numbers in a column results in zero: why?
Thanks everyone! Problem solved.
"Gord Dibben" wrote:
Allewyn
Try this method.
Format the cells as General.
Copy a blank cell and select the others then Paste SpecialAddOKEsc.
Gord Dibben Excel MVP
On Mon, 19 Dec 2005 12:00:02 -0800, "Allewyn"
wrote:
Embedding VALUE as in "=sum(VALUE(A2:A8)) results in the display #VALUE in
the cell
"David Billigmeier" wrote:
<snip
Does that help?
--
Regards,
Dave
"Allewyn" wrote:
When I type in a cell [say cell F1] "=sum(A2:A8)" I get a "0" as the result.
Yes, there are numbers in A2 through A8 which add to 12. Anyone know why the
formula doesn't work? This happens on some sheets in my workbook, but not all
sheets.
Also, another wierd thing: on some cells doing the above reults in the
formula showing as text in the cell. Try THAT one!
|