Counta Closed Workbook

[djfatboyfats]

Hi i need to do a counta on column E to tell me how many payments one of my staff have recieved, the problem i have is that a count will not work on a closed workbook, what else can i use instead, the formula that works is

Please Login or Register  to view this content.

Thanks

DJ

[DonkeyOte]

You could think about using SUMPRODUCT, eg:

=SUMPRODUCT(--('C:\[yourfile.xls]Sheet1'!E17:E1000<>""))

(note the above would discount Nulls from the result whereas COUNTA would not - a Null returned by a formula is not seen as blank by COUNTA - not sure if an issue or not, it's normally seen as a weakness of the COUNTA function in truth)