how do I update this formula to perform the same calculation with N and Y as it did with 0 and 1. N=0 and Y=1
=COUNTIF(T4:T1003,0)/(IF(T4=1,0,1)+COUNTIF(T4:T1003,1))
I tried the following but it gave me "#Value" as a result
=COUNTIF(T4:T1003,"N")/(IF(T4="Y","N","Y")+COUNTIF(T4:T1003,"Y"))
=COUNTIF(T4:T1003,0)/(IF(T4=1,0,1)+COUNTIF(T4:T1003,1))
I tried the following but it gave me "#Value" as a result
=COUNTIF(T4:T1003,"N")/(IF(T4="Y","N","Y")+COUNTIF(T4:T1003,"Y"))