I set up a formula adding a set of numbers in a column, e.g.=sum(c1:c34).
The formula is correct but I got a zero as an answer. I set up the same
formula in another column and it gives me the correct answer, e.g. $2,500. I
tried copying this formula to the first one on the same row. And it returns
$2,500.

What is going on?