Averaging without Hidden Cells
Grabbing an average of a range of cells is easy using Excel functions. If you want that average to ignore hidden cells when the range consists of a row, then Excel doesn't have a way to get what you need. This tip examines a couple of ways you can get around Excel's deficiency.
Read this tip »
(Thanks to Steve Aprahamian, Michael Avidan (Excel MVP), Bob Beechey, Andrija Vrcan, Ioannis Nikolopoulos, and Craig Korfanta for contributing to this tip.)