Thread: Sumif with multiple columns in sum_range
View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.worksheet.functions,microsoft.public.excel.programming,microsoft.public.excel.misc
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
  
Posts: 8,651
Default Sumif with multiple columns in sum_range
For a simple description, type the word SUMPRODUCT into Excel help. For
more detail, type the words SUMPRODUCT and Excel into Google.
--
David Biddulph

"gavin" wrote in message
. ..

"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 :-)



Reply With QuoteReply With Quote