My guess is that some of the "numbers" are text and some are real numbers.
If you insert a column, you can verify it with:
=isnumber(a1)
and drag down
(if your range is in column A)
One quick way to convert all "text numbers" to "number numbers" is to:
copy an empty cell
select your range to convert
edit|paste special|check add
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.