Counting Yes in a Column

I am trying to count the Yes answers in a column compared to No answers, however there are hundreds of hidden rows that i do not want to count, but the countif formula is counting them. how to i exclude the hidden rows from the formula range?

By: Luke Johnson

Leave a Reply

Your email address will not be published. Required fields are marked *