countif.3d

[iceberg]

Hi,

First time here, I hope its works.

I am using =COUNTIF.3D and it works fine.

However what I would like to do is:

=COUNTIF.3D(...) + COUNTIF.3D(...) or COUNTIF.3D(...)/COUNTIF.3D(...) but
that doesn't work on my new version of EXCEL (2003). It used to work on my
older version of EXCEL.

Could you help,

thanks

 

[Dave Peterson]

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/

 

[Gord Dibben]

COUNTIF.3D is a function included in Laurent Longre's Morefunc add-in and is not
native to Excel.

http://xcell05.free.fr/morefunc/english/index.htm


Gord Dibben MS Excel MVP

 

[iceberg]

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

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

 

[Dave Peterson]

Did you install it again?

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

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

 

[T. Valko]

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

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

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

 

[iceberg via OfficeKB.com]

Yes I did.

Did you install it again?

Hi and thanks Dave,

[quoted text clipped - 14 lines]

 

[iceberg via OfficeKB.com]

Yes I did.

Did you install it again?

Hi and thanks Dave,

[quoted text clipped - 14 lines]

 

[Dave Peterson]

I'd visit that site and read the instructions once more.

I don't use this.

Yes I did.

Did you install it again?

Hi and thanks Dave,

[quoted text clipped - 14 lines]

thanks