Have you thought about using a Pivot Table to summarize your results. It
would give you filtering options and much more.

--
Regards,
Ron


"Ant" wrote:

I have a worksheet that records feedback from a training session. The
feedback can be ether strongly agree,, disagree or strongly disagree. I
have used a countif function to count how many of each type of response is
received and then based a chart on the results. This works fine however
using Auto filter I now need to filter the full list to so that I can
compare feedback between trainers or location or training units etc. When I
filter the list, my COUNTIF still counts hidden rows. My question is.... is
there a function like COUNTIF that will only count non filtered items or any
other suggestions on how to solve the problem.

Thanks