Hello, I am working on a project where I need to count how many times a certain phrase appears, while also fulfilling another criteria. Here is the formula I have been using that doesn't seem to be working.
=SUMPRODUCT('05 11 09'!D2:D444="Cannot convert*")*('05 11 09'!G2:G444=1)
It pulls the information off the sheet "05 11 09" and must match the phrase "Cannot convert*" in the D column where it begins with cannot convert and can have any ending. Then it also has to have the value of 1 in the G collumn. When I use this formula, it gives me 0, when it is more than 0. I have tried using the =sum and creating an array, but that hasn't worked either. I can use the countif function for just the first part (counting the cannot converts), but I need it to also match the second criteria.
Any help on this is much appreciated.
Bookmarks