Using Countif with autofillter

J

John

I am trying to use auto filter with the "countif" function?


This Formula gives me a percent for the hole document:

=(COUNTIF(AK3:AK5000,9)+COUNTIF(AK3:AK5000,10))/COUNT(AK3:AK5000)

I want to be able to auto filter the data and have the percent from the
above function change to reflect only the visible info. Basically trying to
count only the number 9 and the number 10 for the visible info divided by the
total number of results within the same column.

ANYHELP????
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top