For your first problem: It is probably because these cell are formated as
text, the sum() function doesn't include these. To fix embed the VALUE()
function, like so: =SUM(VALUE(A2:A8)), and confirm with CTRL+SHIFT+ENTER as
it is an array function.

For your second problem, it is probably the same reason, the cell is
formatted as text before you enter the formula. To fix, change the
formatting to "General" and re-enter the formula.

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!