View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
mndpy mndpy is offline
external usenet poster
 
Posts: 24
Default 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!