Swordfishtrombone
New Member
- Joined
- Jan 25, 2011
- Messages
- 47
I am trying to find an easy way to "construct" a DCOUNT formula using cell references. I was able to use cell references for the Field element in a DCOUNT formula.
=DCOUNTA(DataSet1!$A$1:$A$100,D35,D35:D36)
By changing the values in cell (D35) I am able to change the DCOUNT formula and thereby the results.
But I am trying to figure out to use a similar cell reference to change the data set. I would like to be able to easily change
=DCOUNTA(DataSet1!$A$1:$A$100,D35,D35:D36)
to
=DCOUNTA(DataSet2!$A$1:$A$100,D35,D35:D36)
But I don't seem to be able to put "DataSet1" into a cell and reference that cell address in the formula, the same way I can with the Field or the Criteria variables. So if, for example, cell D1 had the text "DataSet1" in it, how can I incorporate that into the DCOUNT formula?
The overall purpose here is to be able to easily apply the same filters/criteria to different data.
Thanks in advance.
=DCOUNTA(DataSet1!$A$1:$A$100,D35,D35:D36)
By changing the values in cell (D35) I am able to change the DCOUNT formula and thereby the results.
But I am trying to figure out to use a similar cell reference to change the data set. I would like to be able to easily change
=DCOUNTA(DataSet1!$A$1:$A$100,D35,D35:D36)
to
=DCOUNTA(DataSet2!$A$1:$A$100,D35,D35:D36)
But I don't seem to be able to put "DataSet1" into a cell and reference that cell address in the formula, the same way I can with the Field or the Criteria variables. So if, for example, cell D1 had the text "DataSet1" in it, how can I incorporate that into the DCOUNT formula?
The overall purpose here is to be able to easily apply the same filters/criteria to different data.
Thanks in advance.