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