I have a table of data with many rows an columns and I'm trying to count the number of records that meet numerous criteria. I've managed to get a lot of it to work but am stuck when it comes to one field that contains one or more partial string elements. My current formula is: -

=SUMPRODUCT(--(Report!$B$8:$B$99999=$B9),--(Report!$AJ$8:$AJ$99999=""),--(Report!$H$8:$H$99999<3652),--(Report!$L$8:$L$99999<=100000),--(Report!$AG$8:$AG$99999>=1000),--(Report!$K$8:$K$99999>0),--(ISNUMBER(SEARCH(Report!$AQ$8:$AQ$99999,{"funded","exclude"}))))

and this gives me a result. However I would like to search column AQ to count the records that only

*contain*the text fund or exclude (as well as all of the other criteria). I have managed to get it to work with the word "funded" (result is 23in y list) but it won't count when I just use partial text (i.e. "fund"); this just returns zero. If I also add in "exclude" I end up with VALUE.

Could anyone help?

Thanks

Steve