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