Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using SUM with worksheet range selected by two combo boxes
am trying to write a SUM formula that would use the values of two comb
boxes to SUM a range of worksheets. The values for these boxes are in cells: Analysis!B7 Analysis!D7 These values are also dates, which are also the names of the worksheet in the workbook. Lets say the selected dates in the two combo boxes ar 21-Jun-04 and 12-Jul-04, which means the two cells above would have th following values: Analysis!B7 = 21-Jun-04 Analysis!D7 = 12-Jul-04 These cells are in text format. There is a worksheet named 28-Jun-04 i between the previously named sheets, so I am able to sum all three. Il say A1 is the cell I want to add on each sheet. This is what I want t be able to do: =SUM('21-Jun-04:12-Jul-04'!A1) except I want it to be user-selectable, kinda like this: =SUM('ComboBox1.Value:ComboBox2.Value'!A1) Any help would be well appreciated. Thanks, Dou -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using SUM with worksheet range selected by two combo boxes
Try this method:
http://www.mrexcel.com/board2/viewtopic.php?t=57220 -- Regards Juan Pablo González "fifthhorseman " wrote in message ... am trying to write a SUM formula that would use the values of two combo boxes to SUM a range of worksheets. The values for these boxes are in cells: Analysis!B7 Analysis!D7 These values are also dates, which are also the names of the worksheets in the workbook. Lets say the selected dates in the two combo boxes are 21-Jun-04 and 12-Jul-04, which means the two cells above would have the following values: Analysis!B7 = 21-Jun-04 Analysis!D7 = 12-Jul-04 These cells are in text format. There is a worksheet named 28-Jun-04 in between the previously named sheets, so I am able to sum all three. Ill say A1 is the cell I want to add on each sheet. This is what I want to be able to do: =SUM('21-Jun-04:12-Jul-04'!A1) except I want it to be user-selectable, kinda like this: =SUM('ComboBox1.Value:ComboBox2.Value'!A1) Any help would be well appreciated. Thanks, Doug --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Getting Combo boxes to change options based on other Combo boxes. | New Users to Excel | |||
How to clear a group of combo boxes after a submit to another worksheet | Excel Discussion (Misc queries) | |||
Best way to populate worksheet from 2 combo boxes | Excel Worksheet Functions | |||
Selecting subsets using combo boxes or list boxes | Excel Discussion (Misc queries) | |||
Questions on combo boxes and list boxes. | New Users to Excel |