WHY CAN'T I GET MY COLUMN TO SUM?

  • Thread starter Thread starter Guest
  • Start date Start date
julie c. said:
i can get certain columns to sum, but not others, why???
Click to expand...

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


---
 
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?
 
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.
 
Back
Top