Adding more then the allowable 30!

  • Thread starter Thread starter mndpy
  • Start date Start date
M

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!
 
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)
 
That worked Thanks Bob!

Bob Phillips said:
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)
Click to expand...
 
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.
 
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
 
Back
Top