I originally tested in Excel 2002.

I just tested in Excel 2007 and now I see what you mean.

Type in a formula using COUNTIF.3D and the result is #NAME?.

On the Formulas tabInsert functionCategoryMorefunc

COUNTIF3.D is not listed in the available functions.

I also ran across something several months ago while using Excel 2007 and
Morefunc and posted about it.

Again, on the Formulas tabMorefunc groupFunction

When you select a function (any function) the user form doesn't open. I
never use this method so it's not a big deal to me, but....

--
Biff
Microsoft Excel MVP


"Ron Rosenfeld" wrote in message
...
On Tue, 4 Nov 2008 16:30:58 -0500, "T. Valko"
wrote:

I'm not sure which version I have. If I check the properties of
Morefunc.xll
there is no version info.

Whichever version I have, COUNTIF.3D exists and does work.

Not sure what's going on.

I uninstalled morefunc, then reinstalled 5.06. I couldn't download it
again as
I kept getting errors when trying to access the web site.

COUNTIF.3D is in the function list (as it was before). But when I paste
it
into a cell and try to use it, I get a #NAME error.

In addition, the function wizard only shows a single line for an argument.

Are you and Spiky running Excel 2007? If not, I wonder if that could be
the
issue.
--ron