excel do link - How to make a reference to a cell of another sheet, when the sheet name is the value of a cell?
In excel 2007, I have a formula in a cell like the following:
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:
=COUNTIFS(A1!$C:$C;">="&'$A7) // error
Is there is way to do this? Or do I have to write a VBA-Macro for it?
INDIRECT which turns text into a cell reference.
It will probably be something like:
=SUM(E25; -INDIRECT(B8 & " " & B10 & "Discard!E25"))