Unable to Add Values

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Despite formula I use (for example SUM) result is always zero. 4
Significant digit causing wrong value? 2
Adding recognised Zeros 5
Lookup returning wrong results 0
formula to a minimum value of zero if a negative number 2
Displaying zeros in cells 2
Counting Zeros in a row until encounter first non-zero value 9
Excel How to add numbers in same cell? 2

Back
Top