This is what I'm trying to do.
=COUNTIF($H$2:$H$599,"=25")-COUNTIF($H$2:$H$599,"30")

However, it counts cells in hidded rows. I want to count cells in only
unhidded rows. The rowa are hidden as a result of a filtered list.

"pinmaster" wrote:

Hi,

If the rows are hidden as the result of a filtered list then you can use
SUBTOTAL.

=SUBTOTAL(1,A1:A10) for average
=SUBTOTAL(2,A1:A10) for count
=SUBTOTAL(3,A1:A10) for counta

not sure about the countif though!

HTH
Jean-Guy

"dford" wrote:

I'm using COUNTIF and AVERAGE. How do I count or average cells of only
unhidded rows