How to associate a filename with a variable

Question

Instead of:

=ZÄHLENWENN([B16.xlsx]ListeVU!$Y:$Y;F5)

I would like to have like:

=ZÄHLENWENN(["C6".xlsx]ListeVU!$Y:$Y;F5)

But this does not work.

Answer 1

As per my comment you'd need to use INDIRECT(). The right syntax would be:

=COUNTIF(INDIRECT("'["&C6&".xlsx]ListeVU'!$Y:$Y"),F5)

Or in german:

=ZÄHLENWENN(INDIREKT("'["&C6&".xlsx]ListeVU'!$Y:$Y");F5)