| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUM a named range
If I put numbers 1,2,3,4 in a named range "x' in cells a1,a2,a3,a4 and put
SUM(x) in any other cell I get "10" as output, thus correct answer. If I change the formula to "SUM(x^2) I get "1" instead of "30". However when I use the function wizard by clicking on "fx" at the top of the screen the wizard indicates that the correct answer is "30". I press enter and the cell shows "1" instead of "30". Does anyone have any ideas??. Tom Walsh |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional formatting if value in cell is found in a named range | Excel Worksheet Functions | |||
| copy named range to powerpoint | Excel Worksheet Functions | |||
| Using a formula to create named range reference | Excel Worksheet Functions | |||
| named range, data validation: list non-selected items, and new added items | Excel Discussion (Misc queries) | |||
| How to dynamically reference a dynamic named range | Excel Worksheet Functions | |||
Threaded Mode
