| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
cant sum the values in cells
Hi. I cant change properties of cells in a worksheet. I want to
sum the values of cells but the sum returns as 0. Why is that? Thanks Lot. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
cant sum the values in cells
The cells are probably text.
Format an empty cell as Number. Enter the number 1. EditCopy. Select the cells to be summed. EditPaste Special, check Multiply. Now they are numbers and you can sum them. -- Kind regards, Niek Otten Microsoft MVP - Excel "oercim" wrote in message oups.com... | Hi. I cant change properties of cells in a worksheet. I want to | sum the values of cells but the sum returns as 0. Why is that? Thanks | Lot. | |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
cant sum the values in cells
On 10 Temmuz, 13:04, "Niek Otten" wrote:
The cells are probably text. Format an empty cell as Number. Enter the number 1. EditCopy. Select the cells to be summed. EditPaste Special, check Multiply. Now they are numbers and you can sum them. -- Kind regards, Niek Otten Microsoft MVP - Excel "oercim" wrote in ooglegroups.com... | Hi. I cant change properties of cells in a worksheet. I want to | sum the values of cells but the sum returns as 0. Why is that? Thanks | Lot. | Niek thanks but It didint work |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| calculate values in an unlimited range of cells in a column WITHOUTalso calculating values that had previously been filtered AGAINST? | Excel Discussion (Misc queries) | |||
| Exclude #N/A values and Return Numeric values to consecutive cells in Single Row | Excel Worksheet Functions | |||
| find values in multiple cells and paste row values | Excel Discussion (Misc queries) | |||
| There must be a way!!!--set cells' values equal to calculated values in another range | Excel Programming | |||
| average values in non-contiguous cells, ignoring 0 values | Excel Worksheet Functions | |||
Hybrid Mode
