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

"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!.

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

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

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

Thanks for your answers.

I've just found the reason. Some of the cells
contained character "-" instead of "0".

Regards
Neo