Sumproduct-layed out in the standard configuration:

[sanders]

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

[Niek Otten]

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

"sanders" <[email protected]> wrote in message
news:[email protected]...
|
| 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...o&userid=36745
| View this thread: http://www.excelforum.com/showthread...hreadid=569799
|

[Bob Phillips]

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)

"sanders" <[email protected]> wrote in
message news:[email protected]...
>
> 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...o&userid=36745
> View this thread: http://www.excelforum.com/showthread...hreadid=569799
>