As I explained in your identical post of a couple of hours ago, there is no
direct function in Excel to do this. Did you try the method I gave your here

http://www.microsoft.com/office/comm...f-5d303366c788
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"Goody" wrote:

I understand that subtotal 101 calculates an average of cells in a column
without counting the hidden rows. Is there a comparable method to calculate
the average of cells in a row without counting the hidden column values?

Goody