| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
WHY CAN'T I GET MY COLUMN TO SUM?
i can get certain columns to sum, but not others, why???
|
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
WHY CAN'T I GET MY COLUMN TO SUM?
"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 --- |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
WHY CAN'T I GET MY COLUMN TO SUM?
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??? |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
WHY CAN'T I GET MY COLUMN TO SUM?
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 --- |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
WHY CAN'T I GET MY COLUMN TO SUM?
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Column picked randomly with probability relative to number of entr | Excel Worksheet Functions | |||
| how can i multiply two columns | Excel Worksheet Functions | |||
| creating a bar graph | Excel Discussion (Misc queries) | |||
| How to group similar column titles together???? | Excel Discussion (Misc queries) | |||
| Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions | |||
Linear Mode
