Thanks for the correction. Since the basic functionality worked across
columns, and made the bad assumption that it would handle the hiding of
columns.

--
Best Regards,

Luke M
"Mike H" wrote in message
...
Luke,

That only works on columns.
--
Mike

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


"Luke M" wrote:

If you have XL 2003 or later:
=SUBTOTAL(101,A2:E2)

--
Best Regards,

Luke M
"Goody" wrote in message
...
I need to average values in a row, where some columns may be hidden. I
do
not
want the hidden values to be used in the Average calculation. The
hidden
column may not always be the same. Can this be done without itemizing
the
cells in the Average formula?


.