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/Boo...
- Reason - Check D235, number stored a TEXT. Convert it into Number and you wont have the difference in results.
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
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