Adding more then the allowable 30!
 

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!

Adding more then the allowable 30!
 

=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!

Adding more then the allowable 30!
 

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!

Adding more then the allowable 30!
 

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!

Adding more then the allowable 30!
 

That worked Thanks Bob!

"Bob Phillips" wrote:

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!

Adding more then the allowable 30!
 

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.

"mndpy" wrote in message
...
That worked Thanks Bob!

"Bob Phillips" wrote:

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!

Adding more then the allowable 30!
 

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

Just copy the empty cell and PSSpecialAdd

Assuming you have formatted all to General beforehand.


Gord Dibben MS Excel MVP

On Mon, 3 Mar 2008 16:06:47 -0600, "Fred Smith" wrote:

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.

"mndpy" wrote in message
...
That worked Thanks Bob!

"Bob Phillips" wrote:

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!