How to count multiple rows with ISNUMBER

[DCW40]

I was not able to find an answer anywhere, so now I wondering if my approach is wrong. This is the formula I am using =IF(ISNUMBER(SEARCH("pass",$J$1)),"pass",IF(ISNUMBER(SEARCH("fail",$J$1)),"fail","")). This formula does work but now I need it to read row G through J. It needs to be able to find pass or fail in the rows, but I was using the search function because the cells do not simply say pass or fail there are several options, for example one pass option is payment-pass. I have tried everything I can think of to get my formula to count the additional rows with no luck.

 

[Aladin Akyurek]

Is there also a way show a blank cell if no data has been selected?

Try...

=IF(COUNTIFS(G1:J1,"?*"),IF(COUNTIFS(G1:J1,"*pass*")=COLUMNS(G1:J1),"pass","fail"),"")