Hello there,


I'm trying to set up a workbook for a friend that uses the SUMPRODUCT
function in order to count by two different criteria. It's working
wonderfully except for this tiny problem - One of the things I've asked
it to look for is the word "Passed" in one of the columns which works,
however some of the cells can also contain additional wording e.g.
Passed/NR, and these aren't picked up presumabley because they don't
match the criteria exactly.
Is there anyway of altering the formula so it will include these cells?
or is there any other way round this?

Would greatly appreciate any help

As an example

=SUMPRODUCT(--(ISNUMBER(FIND("Passed",D1:D100))),--(E1:E100="yes"))

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Zemmm" wrote in message
oups.com...
Hello there,


I'm trying to set up a workbook for a friend that uses the SUMPRODUCT
function in order to count by two different criteria. It's working
wonderfully except for this tiny problem - One of the things I've asked
it to look for is the word "Passed" in one of the columns which works,
however some of the cells can also contain additional wording e.g.
Passed/NR, and these aren't picked up presumabley because they don't
match the criteria exactly.
Is there anyway of altering the formula so it will include these cells?
or is there any other way round this?

Would greatly appreciate any help