<p>In excel 2007, I have a formula in a cell like the following:</p>

<pre><code>=COUNTIFS('2008-10-31'!$C:$C;"&gt;="&amp;'$A7)
</code></pre>

<p>Now I want to make the name of the sheet ('2008-10-31') be dependent on the value of some cell (say A1). Something like: </p>

<pre><code>=COUNTIFS(A1!$C:$C;"&gt;="&amp;'$A7) // error
</code></pre>

<p>Is there is way to do this? Or do I have to write a VBA-Macro for it?</p>

You are looking for the INDIRECT worksheet function:
```
```
=INDIRECT("SHEET2!A1")
=COUNTIFS(INDIRECT(A1 & "!$C:$C"); ">=" & $A7)
```
```
The function turns a string into a real cell reference.