cant sum the values in cells

  • Thread starter Thread starter oercim
  • Start date Start date
O

oercim

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.
 
The cells are probably text.

Format an empty cell as Number. Enter the number 1. Edit>Copy. Select the cells to be summed. Edit>Paste Special, check Multiply.
Now they are numbers and you can sum them.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| 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.
|
 
The cells are probably text.

Format an empty cell as Number. Enter the number 1. Edit>Copy. Select the cells to be summed. Edit>Paste Special, check Multiply.
Now they are numbers and you can sum them.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


| 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.
|
Click to expand...

Niek thanks but It didint work
 
You must log in or register to reply here.

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

Excel formula, sum the value cell and if empty cell left blank 0
Conditional Formatting with VBA 4
Formula appearing as Value in Formula Bar 1
Sum a variable length column 1
Excel How to add numbers in same cell? 2
Help with VBA and SUM 7
Runtime error 1004 write data to a cell 9
Insert line sum rows 3

Back
Top