On Apr 5, 4:03*am, Steven wrote:
I have a formula such as:

=COUNTA('C:\Accounting\[5010 Advertising.xls]Sheet1'!$C$209:$C$239)

I was wondering if there is a way for example to put in cell A10:
C:Accounting\[5010 Advertising.xls]Sheet1

and then in cell B10 use some sort of concatenation formula or something to
create the COUNTA function by referencing the value (ie filename) in A10
ie: *=CountA(&A10&C209:C239) ... *but that is not it and I cant figure it out.

Thank you for your help.

Steven

Hi Steven,

The INDIRECT function should do what you are after.

Cheers,
Ivan.