|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
October 26th, 2006, 09:09 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
#ARG! - urgent
Hi All!
I have a sheet in MS Excel 97. When I sum the columns, for some of them I get invalid value #ARG!. The sums for the other columns are OK. I can't see any differences between those which sum up properly and those which give the #ARG! as a sum. Please help me. It is a matter of urgency. Regards Neo 
|
|
#2
October 26th, 2006, 09:16 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
#ARG! - urgent
"Neo" wrote in message
... Hi All! I have a sheet in MS Excel 97. When I sum the columns, for some of them I get invalid value #ARG!. I can't answer the question right now, but for those interested, #ARG! is the Polish version of #VALUE!.
|
|
#3
October 26th, 2006, 09:22 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
#ARG! - urgent
I have a sheet in MS Excel 97. When I sum the columns, for some of them I get invalid value #ARG!. I can't answer the question right now, but for those interested, #ARG! is the Polish version of #VALUE!. I use the Polish version and it gives me #ARG!. Neo
|
|
#4
October 26th, 2006, 09:29 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
#ARG! - urgent
Look for cells that contain that same error.
Or if you're adding cells: =a1+a2+a3+... Look for some non-numeric data in any of those cells. Neo wrote: I have a sheet in MS Excel 97. When I sum the columns, for some of them I get invalid value #ARG!. I can't answer the question right now, but for those interested, #ARG! is the Polish version of #VALUE!. I use the Polish version and it gives me #ARG!. Neo -- Dave Peterson
|
|
#5
October 26th, 2006, 09:40 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
#ARG! - urgent
The columns with proper and with invalid sums
were created in the same way, as a copy of combination of other columns (with proper sums) using formulas. Look for cells that contain that same error. Or if you're adding cells: =a1+a2+a3+... Look for some non-numeric data in any of those cells. I have a sheet in MS Excel 97. When I sum the columns, for some of them I get invalid value #ARG!. Neo
|
|
#6
October 26th, 2006, 09:49 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
#ARG! - urgent
Thanks for your answers.
I've just found the reason. Some of the cells contained character "-" instead of "0". Regards Neo
|
|
#7
October 26th, 2006, 11:42 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
#ARG! - urgent
Instead of typing the hyphen in a cell that should be 0, you may want to use the
Accounting format. It shows zeros as hyphens. This won't help your subtotal/sum problem, though. You'll still need the data to be 0's. Neo wrote: Thanks for your answers. I've just found the reason. Some of the cells contained character "-" instead of "0". Regards Neo -- Dave Peterson
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
