software

Hi,

Anybody has an idea how to get the function below to work?

-=COUNT(INDIRECT(\quot;'\quot;amp;B34amp;\quot; (S)\quot;\quot;'!$H:$H\quot;))-

The problem is the -quot; (S)quot;- part, that is the 'constant part' of the
sheet name I'm trying to refer. Is it even possible that I can make
this to work with indirect or should I found another solution?--
Nice
------------------------------------------------------------------------
Nice's Profile: www.excelforum.com/member.php...oamp;userid=17653
View this thread: www.excelforum.com/showthread...hreadid=519369This worked for me

=COUNT(INDIRECT(quot;'quot;amp;B34amp;quot; (S)'!$H:$Hquot;))

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;Nicequot; gt; wrote in message
...
gt;
gt; Hi,
gt;
gt; Anybody has an idea how to get the function below to work?
gt;
gt; -=COUNT(INDIRECT(\quot;'\quot;amp;B34amp;\quot; (S)\quot;\quot;'!$H:$H\quot;))-
gt;
gt; The problem is the -quot; (S)quot;- part, that is the 'constant part' of the
gt; sheet name I'm trying to refer. Is it even possible that I can make
gt; this to work with indirect or should I found another solution?
gt;
gt;
gt; --
gt; Nice
gt; ------------------------------------------------------------------------
gt; Nice's Profile:
www.excelforum.com/member.php...oamp;userid=17653
gt; View this thread: www.excelforum.com/showthread...hreadid=519369
gt;

Thanks Bob,

Just don't understand how come I didn't found the solution now that I
see it...

--
Nice
------------------------------------------------------------------------
Nice's Profile: www.excelforum.com/member.php...oamp;userid=17653
View this thread: www.excelforum.com/showthread...hreadid=519369