Hi there,

Let's say I have the function

=SUMPRODUCT((A2:A10="Monday")*(C2:C10="Apples")*(D 2:D10))

I'm trying to use the SUMPRODUCT function like SUMIF(except for
multiple criteria).

Instead of using "Apples", is it possible to sum everything that
contains the term "Apples"?
BTW, "*Apples*" does not seem to work in this function.

Any ideas how this can be done?alternatives?

Thanks for your help


--
hkoros
------------------------------------------------------------------------
hkoros's Profile: http://www.excelforum.com/member.php...o&userid=24620
View this thread: http://www.excelforum.com/showthread...hreadid=382103