Sumproduct

  • Thread starter Thread starter sanders
  • Start date Start date
S

sanders

Hi,
I currently have a sumproduct formula layed out in the standar
configuration:

=SUMPRODUCT((array1=condition1)*(array2=condition2)*(array3))

Is it possible to change the (array1=condition1) part so that it look
for more than one condition in that array, so that it is looking fo
condition1 OR condition1a?

Thank
 
An extensive description of how SUMPRODUCT can be used can be found here:

http://www.xldynamic.com/source/xld.SUMPRODUCT.html

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|
| Hi,
| I currently have a sumproduct formula layed out in the standard
| configuration:
|
| =SUMPRODUCT((array1=condition1)*(array2=condition2)*(array3))
|
| Is it possible to change the (array1=condition1) part so that it looks
| for more than one condition in that array, so that it is looking for
| condition1 OR condition1a?
|
| Thanks
|
|
| --
| sanders
| ------------------------------------------------------------------------
| sanders's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=36745
| View this thread: http://www.excelforum.com/showthread.php?threadid=569799
|
 
It would be something like

=SUMPRODUCT((array1={"A","B"})*(array3))

but do read the page Nick suggested, it should help explain it all.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
Back
Top