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

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