View Single Post
  #12   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Rosenfeld[_2_] Ron Rosenfeld[_2_] is offline
external usenet poster
 
Posts: 1,045
Default help with Sum in between dates

On Sat, 19 Nov 2011 07:15:32 -0800 (PST), via sarpi wrote:

Ron,

what's the point of using Transpose? doesn't the array have the same
dimension even without transposing?


Yes, but you need to multiply each element in each array by the other; if you don't transpose then you will only do a one-to-one, rather than a one-to-all. Like multiplying two arrays of columns, vs an array of row by an array of columns.