Forum Discussion
Solved
Problem with SUMPRODUCT function
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
https://www.mediafire.com/file/d7ru8c1yjkuaapo/Book1.xlsx/file
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
- Reason - Check D235, number stored a TEXT. Convert it into Number and you wont have the difference in results.
2 Replies
- Reason - Check D235, number stored a TEXT. Convert it into Number and you wont have the difference in results.
- 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
