Hi,

I am using function SUMPRODUCT in the code, the data that I am using as a DB
are exported from other sistem in to the excel.

The problem starts when I want to SUM a few numbers with the same critiria,
all fields have the same settings, but some they come in to result and others
dont.

The data which are not SUMed in result I Just have to type them again in
the same cell that they have been before. And after that evrything is OK.

Any idea what would be the problem?



--
mj