None, IMO. Array formulae are great in that they can do many
things more efficiently than can be done with normal formula,
However, when you can achieve the same funcionality from
a standard formula it is far better to use that, rather than the array.

I should add that this is not an across board sort of thing.
Each situation needs to be assessed on it's merits depending
on what you have and what you are trying to achieve.

HTH
Martin



"wilchong via OfficeKB.com" <u43231@uwe wrote in message
news:83d643a954777@uwe...
This ordinary Excel formula: SUMPRODUCT((x = x )*(y = y)*(z = z),(A:A))
can
be replaced by array formula: {SUM(x = x)*( y = y)*(z = z)*(A:A))}.

Both formula will produce the same result. My question is that what is
the
extra advantage on "array formula" over the ordinary formula.

Please advice.
Wilchong

--
Message posted via http://www.officekb.com