Try this

=COUNTIF(INDIRECT("["&N1&"]"&"Sheet1!$C:$C"),C5)


On Nov 14, 2:56*pm, puiuluipui
wrote:
Hi, i have a number in "C5" and i need to search for this number in another
workbook. I need to search only in column C:C.
But i need an indirect function because the name of book2 will change every
week. I will put in "N1" the name of other workbook.

Can this be done?
Thanks!