#ARG! - urgent

N

Neo

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
 
S

Stephen Bye

Neo said:
Hi All!

I have a sheet in MS Excel 97.

When I sum the columns, for some of them I get
invalid value #ARG!.
Click to expand...

I can't answer the question right now, but for those interested, #ARG! is
the Polish version of #VALUE!.
 
D

Dave Peterson

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.
 
N

Neo

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.
Click to expand...

Neo
 
N

Neo

Thanks for your answers.

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

Regards
Neo
 
D

Dave Peterson

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.
 
Top