Hello,
I want to do a COUNTIF formula but every time I try entering it, it tells me I have too many arguments.
Here is what I want to enter: =(COUNTIF(J2,L2,N2,P2,R2,T2,V2,X2,Z2,AB2,AD2,AF2,AH2,AJ2,AL2,AN2,AP2,AR2,AT2,"Yes"))/19
I basically want to calculate the percentage of times "Yes" appears from the selected cells.
Can anyone suggest what I need to do here to correct the formula?
Bookmarks