ExcelBanter - #VALUE!

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - #VALUE! - urgent (https://www.excelbanter.com/excel-discussion-misc-queries/116303-value-urgent.html)

Neo

#VALUE! - 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!.

As Stephen Bye informed #ARG!. is the Polish version
(which I use at the moment) of #VALUE!.

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

Dave Peterson

#VALUE! - urgent

Check your other thread.

Neo wrote:

Hi All!

I have a sheet in MS Excel 97.

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

As Stephen Bye informed #ARG!. is the Polish version
(which I use at the moment) of #VALUE!.

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

--

Dave Peterson

All times are GMT +1. The time now is 11:04 PM.