WHY CAN'T I GET MY COLUMN TO SUM?

M

Max

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
 
D

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?
 
J

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.
 

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

Similar Threads

Getting the Vertical SUM of a (Custom-Calculated) Duration Field?? 0
Multiple IF Statement in Word 5
Sum data using sumif 3
Send and receive all 0
Can't save my Office documents (after computer rebuild and reauthorization) 0
Get rid of Microsoft AutoUpdate 0
Rolling 4 Week Sum 1
How to center adjust text above and image in a two column document. 1

Top