| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
computing sums
when i try to autosum a column of numbers, what im getting is the formula in
the cell and not the sum. anyone know why this is happening? thanks in advance |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
computing sums
I suspect the cell where you are putting your AutoSum is formatted as Text
Regards Trevor "Holden Caulfield" wrote in message ... when i try to autosum a column of numbers, what im getting is the formula in the cell and not the sum. anyone know why this is happening? thanks in advance |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
computing sums
The cell was formatted as text before the formula was entered.
Format the cell as General and re-enter the formula (F2, ENTER) -- Kind regards, Niek Otten Microsoft MVP - Excel "Holden Caulfield" wrote in message ... | when i try to autosum a column of numbers, what im getting is the formula in | the cell and not the sum. anyone know why this is happening? thanks in | advance |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I add the sums of a group of columns to a series in chart? | Charts and Charting in Excel | |||
| doing sums in excell | Excel Discussion (Misc queries) | |||
| add non-contiguent sums in one column to a Grand Total | Excel Worksheet Functions | |||
| Cummelative sums | Excel Discussion (Misc queries) | |||
| Replace Letter "E" with Letter "C" for 200 Different Sums in a Col | Excel Worksheet Functions | |||
Hybrid Mode
