I've a table where I use countif and if combination and it is working absolutely fine, but when i try to use it arrayformula in breaks.

Formula:

=IF(COUNTIF(A1:D1,"#N/A")-COUNTIF(A1:D1,"")>0,"Ok","No Ok")

Table :-

Is there any way i can use arrayformula with it, I don't want to drag data everytime data increase

Here is the sheet for your reference :-