Using column header as dynamic range

[Vincent88]

Hi, I would like to create below function using the header name in a dynamic table in another workbook as the range.

=COUNTIF([Inventory0221.xlsx]CitiPlaza!Table1[[#Headers],[ Service Tag/Serial No.]],[@[Serial number]])

the range of which I want to use the header name is [Inventory0221.xlsx]CitiPlaza!Table1[[#Headers],[ Service Tag/Serial No.]]

 

[Anthony47]

Cannot guess the complete formula, but as far as the interval is concerned I think you have to use

COUNTIF([Inventory0221.xlsx]CitiPlaza!Table1[ Service Tag/Serial No.], ......)

 

[Fluff]

Will the other workbook always be open?