View Single Post
  #2   Report Post  
Ron Coderre
 
Posts: n/a
Default

Without all of the details, I'm guessing that the SUM equates to zero.

If that is true, the values may be text that appear to be numbers. Try this
to correct the problem:

1)Put a 1 in a blank cell and select that cell
2)EditCopy
3)Select the imported values
4)EditPaste Special
--Select Multiply
--Select Values
Click the [OK] button.

Does that resolve the problem?

--
Regards,
Ron


"jnorton" wrote:

I have a sql query that imports data from a MySQL database.
When the data is brought into Excel I can't sum the numbers.