Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
# of allowable characters in Excel 2003 cell | Excel Discussion (Misc queries) | |||
VLOOKUP - Allowable Number Sequence | Excel Worksheet Functions | |||
adding ref # | Excel Worksheet Functions | |||
Adding Up! | Excel Discussion (Misc queries) | |||
what is the correct syntax for an allowable circular reference? | Excel Discussion (Misc queries) |