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

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/



iceberg wrote:

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

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

Did you install it again?

iceberg wrote:

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


--

Dave Peterson

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

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

On Thu, 21 Feb 2008 17:20:25 GMT, "iceberg" <u41552@uwe wrote:

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