stuck with filtered results!!!!

[RetrogradePAK]

i have a column in which the cells contain values like "Agree", "Disagree","Agree - comments". The countif works fine in totalling but it does not work when i use filter coz obviously in countif you define a static cell range.

Can anyone help, tried many things but to no avail

 

[SkipVought]

gogadrum,

I notice that over the past 6 years, you have posted 79 threads and have received many good tips related to your stated needs. Yet, you have responded only ONCE, to
[blue]
Thank Tek-Tip Contributor
for this valuable post![/blue].

The Stars accomplish several important things.

First, it gives positive feedback to contributors, that their posts have been helpful.

Second, it identifies threads as containing helpful posts, so that other members can benefit.

And third, it identifies the original poster (that's YOU, BTW), as a grateful member, that not only receives, but is willing to give tokens of thanks.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}