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?