Problem with SUMPRODUCT function

[Ahmed_Hatem]

I have a problem with the SUMPRODUCT function
It is not working properly
I want to know why this error

Attached is a file explaining the problem

SUMPRODUCT 

when use
=SUMPRODUCT([Unit Price (L.E)],[Original Quantity]*(1))
The result is given as correct

but when use
=SUMPRODUCT([Unit Price (L.E)],[Original Quantity])
The result is given as incorrect

[#2 · Accepted solution]

Reason - Check D235, number stored a TEXT. Convert it into Number and you wont have the difference in results.

[#3]

Thank you
In the big sheet
It did not appear or attract attention
On your advice
Sheets are revised by incrementing decimal places
What does not have decimal points is known to be text and not a number