Hi

When Define is greyed out, then probably you have the worksheet, from where
you tried to open the Name Define Wizard, protected. Unprotect the sheet
before, after that try again.

And highlighting the range is not helping you in any way - you are creating
a named formula (returns a value), not a range, so simply enter the formula
into RefersTo field. Probably you have to use non-array SUMPRODUCT instead
of SUM as array formula, because you can't enter formulas with
Ctrl+Shift+Enter in Name Define Wizard (sometimes Excel can decide, that the
formula must be an array one, and behaves accordingly, but it doesn't work
100%).


Arvi Laanemets



"Richard Buttrey" wrote in
message ...
On Thu, 29 Sep 2005 15:44:46 +0300, "Arvi Laanemets"
wrote:

Hi

=IF(divisor=0,"",large_formula)

Furthermore, you can define parts of your large_formula as names (named
functions), so that the whole will look like
=IF(Name2=0,"",Name1/Name2)


Arvi,

That's an interesting idea, please tell me more.

How do I name part of the formula. I tried highlighting the relevant
part and going to Insert Name Define as you'd normally do, but the
define bit is greyed out. The Excel help wasn't much help when I
looked.

Rgds
__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________