Need some help - need to include another criteria for my formula. Currently has a CountIF, and it works. When I change to CountIFS to add the extra criteria (001), it stops calculating for everything. I also tried adding to include in my "Default" named range (range off to the far right) but cant get that to work either, I think because I have to store number as text to get 001 to show. See attachment. also examples below.
Formula currently: =IF(COUNTIF(E10:I10,"*999*")+SUMPRODUCT(--(DEFAULT=E10:I10))>0,1,"")
Formula I want to work: =IF(COUNTIFS(E16:I16,"*999*",E16:I16,"*001*")+SUMPRODUCT(--(DEFAULT=E16:I16))>0,1,"")
default named range includes: 101, 102, 104, 105, 107, 108, 999
appreciate the help on this one!
Bookmarks