# why display formula instead of result?

spreadsheet sometimes shows formula =sum(k17:k34) instead of showing the result of adding the contents of that range of cells. Other times, it displays all zeroes as a result of a similar formula.

For the first question,

View -> Show Formula. For the second, more details are needed. What values are summed, and what is the cell number format (Format -> Cells)? For example, if A1 contains`a`

and B1 contains`="1"`

, then`=SUM(A1:A2)`

results in 0 because strings have zero numeric value.