Adding more then the allowable 30!

[mndpy]

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!

 

[Trevor Williams]

=SUM(AM113:AM175)

 

[Bob Phillips]

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]

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

 

[mndpy]

That worked Thanks Bob!

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)

 

[Fred Smith]

If that's the case, it means your data is text, not numbers. It will make
your life easier if you converted your data to numbers, then all functions
will work for you. To convert to numbers:

1. Put 0 in an empty cell.
2. Copy that cell.
3. Highlight your range.
4. Right click on your range, and choose Paste Special...>Add
5. Delete the cell from point 1

Regards,
Fred.

 

[Gord Dibben]

An empty cell equates to 0. No need to enter it.

Just copy the empty cell and PS>Special>Add

Assuming you have formatted all to General beforehand.


Gord Dibben MS Excel MVP