View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
PBcorn PBcorn is offline
external usenet poster
 
Posts: 79
Default sumproduct query

Probably a simple query - I wish to use 6 sumproduct formulae to multiply
each row of a 7x6 array by one single 1x6 array. Is this possible without
typing out each ofthe 6 sumproduct formulae individually, or expanding the
1x6 array to a 7x6 array?