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

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/