| Home |
| Search |
| Today's Posts |
|
#10
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding numbers in a column results in zero: why?
Thanks everyone! Problem solved.
"Gord Dibben" wrote: Allewyn Try this method. Format the cells as General. Copy a blank cell and select the others then Paste SpecialAddOKEsc. Gord Dibben Excel MVP On Mon, 19 Dec 2005 12:00:02 -0800, "Allewyn" wrote: Embedding VALUE as in "=sum(VALUE(A2:A8)) results in the display #VALUE in the cell "David Billigmeier" wrote: <snip Does that help? -- Regards, Dave "Allewyn" wrote: When I type in a cell [say cell F1] "=sum(A2:A8)" I get a "0" as the result. Yes, there are numbers in A2 through A8 which add to 12. Anyone know why the formula doesn't work? This happens on some sheets in my workbook, but not all sheets. Also, another wierd thing: on some cells doing the above reults in the formula showing as text in the cell. Try THAT one! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| abdualmohsn | Excel Discussion (Misc queries) | |||
| match and count words | Excel Worksheet Functions | |||
| Average of numbers in column between to other numbers | Excel Discussion (Misc queries) | |||
| Adding more than 30 numbers in a column | Excel Worksheet Functions | |||
| GET NON-ZERO RESULTS USING STDEV FOR CERTAIN NUMBERS | Excel Worksheet Functions | |||
Threaded Mode
