excel adding error?

H

h.

is it possible that excel makes a calculation error when adding a column?

we have a spreadsheet with amounts and we are just using the simple autosum
formula to total them up. i have no idea why but if you manually add these
amounts it does not equal the total that excel has calculated. we have tried
many times and everyone is getting the same answer.

help!
 
G

Gary''s Student

You probably have a value in the column that only appears to be a number, but
is actually a Text value. SUM() will treat this value as zero.
 

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