Thread: Sumif with multiple columns in sum_range
View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.worksheet.functions,microsoft.public.excel.programming,microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
  
Posts: 35,218
Default Sumif with multiple columns in sum_range
Bob Phillips explains =sumproduct() in much more detail he
http://www.xldynamic.com/source/xld.SUMPRODUCT.html

gavin wrote:

"Ron Coderre" wrote in message
...
Try this approach:

=SUMPRODUCT((A2:A10="Joel")*B2:C10)

I can never get my head round the SUMPRODUCT function. Can anyone explain in
very simple terms(!!!) what it does :-)

--

Dave Peterson
Reply With QuoteReply With Quote