| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
sum formula in excel
I have never used formulas in excel before and am battling a bit.
I am trying to add just one simple column of numbers but am having no luck. I double click on the cell where I want the total to be and then click on auto sum, then 'highlight' the cells I want to be added up and then press enter. The answer I receive is =SUM(H4:H31) which is the correct span of cells. Why is it not giving me the total in numbers? Please help I am going crazy!! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
sum formula in excel
You might be in the show formula mode - press CTRL + ~ and see if that
helps... pippawl wrote: I have never used formulas in excel before and am battling a bit. I am trying to add just one simple column of numbers but am having no luck. I double click on the cell where I want the total to be and then click on auto sum, then 'highlight' the cells I want to be added up and then press enter. The answer I receive is =SUM(H4:H31) which is the correct span of cells. Why is it not giving me the total in numbers? Please help I am going crazy!! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
sum formula in excel
Go To Tools Options Tab Formulas
and make sure that it is NOT checked "pippawl" wrote: I have never used formulas in excel before and am battling a bit. I am trying to add just one simple column of numbers but am having no luck. I double click on the cell where I want the total to be and then click on auto sum, then 'highlight' the cells I want to be added up and then press enter. The answer I receive is =SUM(H4:H31) which is the correct span of cells. Why is it not giving me the total in numbers? Please help I am going crazy!! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
sum formula in excel
wrote:
You might be in the show formula mode - press CTRL + ~ and see if that helps... I have never used formulas in excel before and am battling a bit. [quoted text clipped - 9 lines] Please help I am going crazy!! Problem sorted thanks for the help! -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200609/1 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
sum formula in excel
Florida User wrote:
Go To Tools Options Tab Formulas and make sure that it is NOT checked I have never used formulas in excel before and am battling a bit. [quoted text clipped - 9 lines] Please help I am going crazy!! It's doing what it should now thanks! -- Message posted via http://www.officekb.com |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Reusing formula | Excel Discussion (Misc queries) | |||
| Excel Formula Issue | Excel Discussion (Misc queries) | |||
| Match then lookup | Excel Worksheet Functions | |||
| converting formula from lotus.123 to excel | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
Linear Mode
