What if the column has 'Yes, No & N.A (or UNKNOWN)? How to subtract that so the calculation is done among the ones only with Yes / No excluding at all the ones with N.A.? Thanks
=COUNTIF(D4:D23,”yes”)/(COUNTIF(D4:D23,”no”)+COUNTIF(D4:D23,”yes”)) Enter this formula into the cell in which you want to display the percentage. Do not change anything on the above formula besides the area the formula is calculating. For example your data may be A1:A20. So in my formula change D4:D24 to A1:A20.
=COUNTIF(D4:D23,”yes”)/(COUNTIF(D4:D23,”no”)+COUNTIF(D4:D23,”yes”)) Enter this formula into the cell in which you want to display the percentage. Do not change anything on the above formula besides the area the formula is calculating. For example your data may be A1:A20. So in my formula change D4:D24 to A1:A20.
you explain very well, but your channel is too old and you haven't reached too many subs. So what if you add some music to your videos? keep it up. I love your channel
It was Helpfull- I used it and it easy to understand - Thank you Jignesh Gupta
What if the column has 'Yes, No & N.A (or UNKNOWN)? How to subtract that so the calculation is done among the ones only with Yes / No excluding at all the ones with N.A.? Thanks
=COUNTIF(D4:D23,”yes”)/(COUNTIF(D4:D23,”no”)+COUNTIF(D4:D23,”yes”))
Enter this formula into the cell in which you want to display the percentage. Do not change anything on the above formula besides the area the formula is calculating. For example your data may be A1:A20. So in my formula change D4:D24 to A1:A20.
Thank you
you saved me! thanks !
thank you so mutch!!!
=COUNTIF(D4:D23,”yes”)/(COUNTIF(D4:D23,”no”)+COUNTIF(D4:D23,”yes”))
Enter this formula into the cell in which you want to display the percentage. Do not change anything on the above formula besides the area the formula is calculating. For example your data may be A1:A20. So in my formula change D4:D24 to A1:A20.
and how to find mean and sd please from the yes and no?
How to find ratio out of 100%
you explain very well, but your channel is too old and you haven't reached too many subs. So what if you add some music to your videos? keep it up. I love your channel
Thank you