View Single Post
  #15   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max Max is offline
external usenet poster
 
Posts: 9,221
Default Array help Part 2

One main versatility in using SUMPRODUCT is that we don't need* to
array-enter the expression for it to evaluate the nested arrays within.
*Except perhaps if TRANSPOSE is nested within the SD,
viz: =SUMPRODUCT(TRANSPOSE(...) ...)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---