| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Trying to sum column but getting 0 as result
The cells are probably text, although they look like numbers and you
formatted them as numbers after pasting them. Format an empty cell as Number. Enter the number 1. EditCopy. Select your "numbers". EditPaste special, check Multiply -- Kind regards, Niek Otten "telewats" wrote in message ... I've copied information into an excel spreadsheet, and I'm trying to sum certain columns, however my formula is returning the result of "0". The column I'm trying to total has numbers such as 2.0, 16.0, etc. so I'm thinking it has something to do with the formatting in these cells, however I can't figure out what to do to make it work. Can someone please help! -- telewats ------------------------------------------------------------------------ telewats's Profile: http://www.excelforum.com/member.php...o&userid=30270 View this thread: http://www.excelforum.com/showthread...hreadid=500378 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert number into words | Excel Discussion (Misc queries) | |||
| How to .. | Excel Discussion (Misc queries) | |||
| Formula to lookup Multiple Column Text and then Count Result | Excel Worksheet Functions | |||
| I NEED HELP with the SPELLNUMBER Function | Excel Worksheet Functions | |||
| Convert Numeric into Text | Excel Worksheet Functions | |||
Hybrid Mode
