Thread: Sumproduct
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
PA
 
Posts: n/a
Default Sumproduct

A brief explanation would be appreciated:
What is the difference between
=sumproduct((A2:A100),(B2:B100))
versus
=sumproduct((A2:A100)*(B2:B100))

I have been reading about the many uses of this function, and can not figure
this out

Thanks
Paul