| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula won't show sum
I'm a novice...and self-taught, but I love Excel. Can someone please explain
why when I enter a formula to add a column of numbers, the formula is showing in the cell and not the sum. the formula is: =sum(e27:e42) Have they changed how a formula is written in Excel 2007? Even after I format the cells to be numbers versus text, the sum function won't show a sum...just the formula. Sometimes all I get is a zero. How can I fix this? It's very frustrating. Thx. -- Novice Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Show and copy values in formula bar containing a formula | Excel Discussion (Misc queries) | |||
| Dont show formula in formula bar | Excel Discussion (Misc queries) | |||
| formula to show a formula in a different cell | Excel Worksheet Functions | |||
| I want the results of a formula to show in cell, NOT THE FORMULA! | Excel Discussion (Misc queries) | |||
| Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions | |||
Threaded Mode
