F
fifthhorseman
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
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