Simplifying an IF(OR function with a range of cells

[CSachark]

This may not be a thing but I sure hope it is!

I would to utilize a formula SIMILAR to below, I clearly haven't written is as excel would like as it is not returning results.

J4=IF(OR(d4:k4="x",d4:k4="Y"),"Complete","Active")

So, if ALL of those cells contains one of those two status',the overall status shall be "Complete" but if ANY of those 8 cells contains one of the many, many other status' then the overall status shall be "active"


EDIT: Oops: ** I would like to utilize **

 

[Joe4]

Welcome to the Board!

Maybe something like this:

=IF(COUNTIF(D4:K4,"x")+COUNTIF(D4:K4,"Y")=8,"Complete","Active")