Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
values not appearing in autofilter list | Excel Discussion (Misc queries) | |||
LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
How to Search, Count, Match and Post Values | Excel Worksheet Functions | |||
How do I generate a list from a range of values | Excel Worksheet Functions | |||
Keeping a cell value constant trhoughout a list of values | Excel Worksheet Functions |