A
Alan
Hi,
Will COUNTIF work on a range in another workbook if that other workbook
is not open?
Thanks,
Alan
Will COUNTIF work on a range in another workbook if that other workbook
is not open?
Thanks,
Alan
F
Frank Kabel
Hi alan
as a short test revails: No
But you can try the following:
If your current formula looks like:
=COUNTIF(range,condition)
replace it with
=SUMPRODUCT(--('c:\path\[file.xls]Sheet1'!range=condition))
as a short test revails: No
But you can try the following:
If your current formula looks like:
=COUNTIF(range,condition)
replace it with
=SUMPRODUCT(--('c:\path\[file.xls]Sheet1'!range=condition))