row count, column totals (after filter applied)

[topgun-usaf]

Hi
I would like somebody to help me with the following:

How can I apply a total row count of the results that the filter has found?

How can I total columns of the results that the filter has found?

I am using Excel 2010

The filter criteria will be constantly changing.

Thank you

 

[Tuelor]

Have you tried using a pivot table? You could add some vba to make it more flexible if needed.

D