[SOLVED] counta,countif with range versus entire column I have a list of yes/no answers and want to calculate a percentage. I was accomplishing this by using =COUNTIF(A2:A37,"yes"/(COUNTA(A2:A37)). But, as the list will just continue to get longer with time and new data, I changed the formula to =COUNTIF(A:A,"yes"/(COUNTA(A:A)) but the result is...
https://www.excelforum.com/sho....wthread.php?t=142326