hi guys,

this is my problem:

in a sumproduct function, i want to sum the columns that fulfil four
criterias.

The nagging problem is tat in one of the criteria , i want it to picked
out (from the

assigned column) either " tube " or " patch" but i do not know how to
do it . Can


anyone advise me on this? I came across some sumproduct where people
use

the + sign in a sumpdt function. Can i use it for my case ?


my function: =
(SUMPRODUCT(--(tyre_procure!$E$2:$E$10001=4086),--(tyre_procure!$B$2:$B$10001="Oct"),--(tyre_procure!$J$2:$J$10001="Solid"),--(tyre_procure!$K$2:$K$10001=REPLACE(C7,7,1,"")),--(ISNUMBER(FIND("patch",tyre_procure!$F$2:$F$10001) )),tyre_procure!$H$2:$H$10001))


the problem lies in the criteria colored in red. i wan to make
adustments so that the function will picked out either the word
"patch " or "tube" in column F


--
cjjoo
------------------------------------------------------------------------
cjjoo's Profile: http://www.excelforum.com/member.php...o&userid=26916
View this thread: http://www.excelforum.com/showthread...hreadid=486158