Hi Tom,

Thanks for your reply.

What makes this an array formula rather than just a normal formula? It looks
like the latter, without the { } around it.

Kel

"Tom Ogilvy" wrote in message
...
Yes.

Insert Name Define
Name: MyNamedArrayFormula
RefersTo: =Sum(($A$1:$A$10=5)*($B$1:$B$10=2)*$C$1:$C$10)

If you want to use relative addresses, then these will be relative to the
activecell. With named ranges, best to use absolute references in most
cases.

--
Regards,
Tom Ogilvy


"Kel Good" wrote in message
...
Is it possible somehow to define a array formula and give it a name like
you
do normal named formulas, so it can be used in a cell like so:

=MyNamedArrayFormula

Thanks.

---------------------------------------------------------------
Kel Good
MCT, MCAD, MCSD for Microsoft.NET