Subtotal across a row

[Goody]

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

 

[Mike H]

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/com...d3a5&cid=0a36ac86-c9e8-43b7-b5af-5d303366c788
--
Mike

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