| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
#VALUE! result when using defined name in formula
I am learning how to name cells and use these names.
I tried to name a cell in my Summary sheet using the sum of cells in my Detail sheet. When I press enter, the cell returns a #VALUE! What am i doing wrong? Trina |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
#VALUE! result when using defined name in formula
That means there's a #VALUE! error in your sum range. Go check & clean it up,
the sum should work fine -- Max Singapore --- "Tacrier" wrote: I am learning how to name cells and use these names. I tried to name a cell in my Summary sheet using the sum of cells in my Detail sheet. When I press enter, the cell returns a #VALUE! What am i doing wrong? Trina |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula result does not match displayed result | Excel Worksheet Functions | |||
| Text and defined name result in same cell | Excel Worksheet Functions | |||
| Color a result cell in a user defined function | Excel Discussion (Misc queries) | |||
| Advanced formula - Return result & Show Cell Reference of result | Excel Worksheet Functions | |||
| Comparing a cell result with a pre-defined value range | Excel Worksheet Functions | |||
Linear Mode
