Unable to Add Values
This is really simple but I can't find the answer!
Just doing a simple formula adding up a row of numbers and the result always returns zero. The numbers have been exported out of a database and are in number format. The only way i can get them to add up is if I type in the number again. |
Unable to Add Values
Sounds like the numbers are text format, a common problem when dealing with
downloaded data. Check it by trying =SUMPRODUCT(--A1:A100) and see if you get a result. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Phish76" wrote in message ... This is really simple but I can't find the answer! Just doing a simple formula adding up a row of numbers and the result always returns zero. The numbers have been exported out of a database and are in number format. The only way i can get them to add up is if I type in the number again. |
All times are GMT +1. The time now is 07:33 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com