Thread: The extraordinary advantage of "Array Formula"
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
wilchong via OfficeKB.com wilchong via OfficeKB.com is offline
external usenet poster
  
Posts: 90
Default The extraordinary advantage of "Array Formula"
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

Reply With QuoteReply With Quote