Problem with SUMPRODUCT

[Guest]

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?

 

[papou]

Hello
Looks like it's to do with your source data value not being "recognized" in
Excel.
I would suggest:
Input 1 into an empty cell
Copy this specific cell
Select your "corrupted" data
Paste special, operation = multiply

You may also consider coding this operation.

HTH
Cordially
Pascal