Building the sheet name from two parts?

N

Nice

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?
 
B

Bob Phillips

This worked for me

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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
N

Nice

Thanks Bob,

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

:)
 
Top