Check out the SUBTOTAL function in Help.

On Tue, 19 Jul 2005 13:07:02 +0000, dcotejr
wrote:


I am trying to determine the best way to perform calculations
(summation, average, etc.) on cells that are unhidden in a spreadsheet.
After hiding the unused cells, what is the best way to accomplish this?
Copy and Paste Special? Or is there some easier method? Thanks in
advance! dcotejr