WHY CAN'T I GET MY COLUMN TO SUM?

[julie c.]

i can get certain columns to sum, but not others, why???

[Max]

"julie c." wrote:
> i can get certain columns to sum, but not others, why???

One guess is that the numbers in the col are "text numbers"
Try this to convert to real numbers:
Input in an empty cell the number 1, then copy it
Then right-click on the col > paste special > multiply > ok

--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

[David D]

Can you post your worksheet here?

Is there anything different about the column that won't sum? Perhaps its
formatting, the way the data was entered, or the layout?

--
-David D


"julie c." wrote:

> i can get certain columns to sum, but not others, why???

[julie c.]

Just started using excel yesterday. This program is great. I realized my
formula resulted in text. Recalculated formula to give a numerical result.
Thanks for your time! I bet I have alot to learn. Thanks again, Julie C.


"Max" wrote:

> "julie c." wrote:
> > i can get certain columns to sum, but not others, why???
>
> One guess is that the numbers in the col are "text numbers"
> Try this to convert to real numbers:
> Input in an empty cell the number 1, then copy it
> Then right-click on the col > paste special > multiply > ok
>
> --
> Max
> Singapore
> http://savefile.com/projects/236895
> xdemechanik
> ---

[Max]

Glad to hear you got it going !
Thanks for the feedback ..
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"julie c." wrote:
> Just started using excel yesterday. This program is great. I realized my
> formula resulted in text. Recalculated formula to give a numerical result.
> Thanks for your time! I bet I have alot to learn. Thanks again, Julie C.