Problems with Sumproduct formulas
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 |
Problems with Sumproduct formulas
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 |
All times are GMT +1. The time now is 10:08 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com