| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
sum formula not working excel 03
The formula:
=sum(h10,h14,h20,h40) The result should be: =sum(4,5,4,4,4,) =21 I however get 20 as a result. Tools/Options is set to automatic and the "h" cells are formatted as numbers (1234). The cells are dependent on other formulas (=sum(h11:h12)/2) etc. The cells in between is formatted to numbers (1234.10) Any suggestions anyone |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel drag down formula not working good.. | Excel Worksheet Functions | |||
| Formula not working in excel 2007 | Excel Discussion (Misc queries) | |||
| I've got a problem with an Excel formula I'm working on. | Excel Discussion (Misc queries) | |||
| Excel formula not working | Setting up and Configuration of Excel | |||
| Excel formula not working | Excel Discussion (Misc queries) | |||
Threaded Mode
