That doesn't work it is still giving an answer of 0.

"Trevor Williams" wrote:

=SUM(AM113:AM175)


"mndpy" wrote:

I want to sum AM113 to AM175 I've tried the numerous ways I've found in the
answers in other posts however it always shows an answer of 0 and it doesn't
work. If anyone has any suggestions I would appreciate it. The number it is
calculating in those cells are not by any means complicated. They are all 1.
Thanks!