Sum formula returning zero value

[Teresa Devlin]

I am trying to sum a column with values using a report downloaded from Celltracker, however the sum total is returning as zero. When added using =a1+a2 the value returns correctly.

 

[spedomes]

thank you

 

[Person1307]

Hi All

None of the above worked for me, but...

This was SOLVED (when the above option didn't work) by noting that there were circular references within the sheet (not directly noticeable within the formula itself, but stopping the calculation from working correctly). Take a look in the very bottom left (as you look at the screen) just above the Window button next to the Macro indicator - this should show any circular references. Solve these, and the Sum formula should magically start working again.

Hope that solves it for you too.