Building the sheet name from two parts?

Hi,

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

=COUNT(INDIRECT("'"&B34&" (S)""'!$H:$H"))

The problem is the " (S)" 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?

This worked for me

=COUNT(INDIRECT("'"&B34&" (S)'!$H:$H"))

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Nice" <[email protected]> wrote in message
news:[email protected]...
>
> Hi,
>
> Anybody has an idea how to get the function below to work?
>
> -=COUNT(INDIRECT(\"'\"&B34&\" (S)\"\"'!$H:$H\"))-
>
> The problem is the -" (S)"- 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:
http://www.excelforum.com/member.php...o&userid=17653
> View this thread: http://www.excelforum.com/showthread...hreadid=519369
>

Thanks Bob,

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