Your formula syntax may be correct, but SUM still returns 0. This usually happens because the values look like numbers while they are actually stored as text, and SUM does not count text.
Read the cause below, then click Run to see how the formula works on the grid and why the result goes wrong.
=SUM(C1:C6)Loading the interactive example…