| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using Data from Drop Down Menus in Sum Formulas
Formatting doesn't change underlying values. I wonder if you did array-enter
the suggested formula correctly? It should work ok. If you did array enter it correctly you should see that the formula is wrapped with curly braces: { } in the formula bar. These braces are inserted by Excel. Perhaps try it again? Just click inside the formula bar where you placed: =SUM(I1:I10+0), then press CTRL+SHIFT+ENTER. The addition of the zero: +0 should suffice to coerce the text numbers within I1:I10 to real numbers, but the formula needs to be array-entered. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Will Emms" wrote: Hi Max, Thanks for that but that still doesn't seem to work. Do you think I might need to format the numbers in the drop down menu? What do you reckon? Will |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Old data in Pivot Table drop-down menus | Excel Discussion (Misc queries) | |||
| Drop-down menus to store different data | Excel Worksheet Functions | |||
| Adding sub-menus and actions to data in drop down lists in Excel 2 | Excel Worksheet Functions | |||
| Drop-Down Menus in Data Entry Form? | Excel Discussion (Misc queries) | |||
| formulas for drop down menus | Excel Discussion (Misc queries) | |||
Threaded Mode
