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.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
How to count multiple rows with ISNUMBER
Aladin Akyurek
MrExcel MVP
- Joined
- Feb 14, 2002
- Messages
- 85,210
Try...
=IF(COUNTIFS(G1:J1,"?*"),IF(COUNTIFS(G1:J1,"*pass*")=COLUMNS(G1:J1),"pass","fail"),"")
Upvote
0
Excel Facts
Is there a shortcut key for strikethrough?
Ctrl+S is used for Save. Ctrl+5 is used for Strikethrough. Why Ctrl+5? When you use hashmarks to count |||| is 4, strike through to mean 5.
