Thread: Array with Sum and multiply
View Single Post
  #11   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Harlan Grove[_2_] Harlan Grove[_2_] is offline
external usenet poster
  
Posts: 1,231
Default Array with Sum and multiply
"Rick Rothstein" wrote...
What about this way...

=SUMPRODUCT(A2:A6*B2:D6)

Or

=SUMPRODUCT(A2:A6,B2:D6)
Reply With QuoteReply With Quote