SUM Function

E

EbonLinctus

I imported a table from Access (2003) into Excel (2003). A column that
contains numbers do not add correctly using the SUM function; however, it
adds correctly if I enter the formula as =A1+A2+A3+A4.

I know that data stored in Access may not be stored the same in Excel after
import. But even if I format the data in Excel (e.g., to Number), it still
does not calculate correctly using the SUM function.
 
J

Joe User

EbonLinctus said:
A column that contains numbers do not add correctly
using the SUM function; however, it adds correctly
if I enter the formula as =A1+A2+A3+A4. [....]
But even if I format the data in Excel (e.g., to Number),
it still does not calculate correctly using the SUM function.

Some or all of the cells are probably contain text. You can confirm this
entering =TYPE(A1) in a parallel column and copying down through A4 (or
whatever). If the result is 2 somewhere, the cell contains text.

Changing the format to Number does not change the type of the content. You
can put the number 1 into a cell, copy it, then select the cells containing
text, right-click and press Paste Special > Multiply > OK.
 

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

Top