How to associate a filename with a variable-CodePudding

Home > Mobile > How to associate a filename with a variable

How to associate a filename with a variable

Time：09-01

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.

CodePudding user response：

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)