| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using Data from Drop Down Menus in Sum Formulas
Hi there,
I'd like to set up a spreadsheet with numerical drop down menus, the selected values of which can then be taken and added together using the sum function. I've tried adding in a drop down using the forms tool bar but sum function won't seem to add the values. Can anybody help? Thanks Will |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Using Data from Drop Down Menus in Sum Formulas
Think the numbers you are trying to sum are text numbers
Instead of, say: =SUM(I1:I10) Try, array-entered, ie press CTRL+SHIFT+ENTER instead of just pressing ENTER: =SUM(I1:I10+0) -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Will Emms" wrote: Hi there, I'd like to set up a spreadsheet with numerical drop down menus, the selected values of which can then be taken and added together using the sum function. I've tried adding in a drop down using the forms tool bar but sum function won't seem to add the values. Can anybody help? Thanks Will |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Using Data from Drop Down Menus in Sum Formulas
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 "Max" wrote: Think the numbers you are trying to sum are text numbers Instead of, say: =SUM(I1:I10) Try, array-entered, ie press CTRL+SHIFT+ENTER instead of just pressing ENTER: =SUM(I1:I10+0) -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Will Emms" wrote: Hi there, I'd like to set up a spreadsheet with numerical drop down menus, the selected values of which can then be taken and added together using the sum function. I've tried adding in a drop down using the forms tool bar but sum function won't seem to add the values. Can anybody help? Thanks Will |
|
#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 |
| Reply |
| 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) | |||
Linear Mode
