it was working before, but now it is not.

That's not very descriptive!

From Morefunc help on COUNTIF.3D

The 3D reference can refer to an external range
('[File.xls]Sheet1:Sheet8'!A1:C30), but the source file must be open. Its
size is limited to 65536 items (therefore, the 3D range can't contain more
than 65536 cells).



--
Biff
Microsoft Excel MVP


"iceberg" <u41552@uwe wrote in message news:801340fde0319@uwe...
Hi and thanks Dave,

Your are right, it comes from morefunc.xll. However it was working before,
but now it is not. So if somebody knows enough about morefunc.xll to help
that would be appreciated.

thanks

Dave Peterson wrote:
This isn't part of xl2003 (USA function names, anyway).

It looks like it may be part of Laurent Longre's addin (morefunc.xll) at:
http://xcell05.free.fr/

Hi,

[quoted text clipped - 11 lines]

thanks