maybe try

=SUMPRODUCT(--(AM113:AM175))

if the numbers are all text

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"mndpy" wrote in message
...
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!