Unable to Add Values

P

Phish76

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.
 
B

Bob Phillips

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)
 
Top