Posted to microsoft.public.excel.worksheet.functions,microsoft.public.excel.programming,microsoft.public.excel.misc
|
|
Sumif with multiple columns in sum_range
"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 :-)
|