Average without Hidden Cells
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?
.
|