Formula only for visible Cells

L

lightbulb

Is there a way to make a function apply only to visible cells, in otherwords
not include a cell if it is hidden?

Thanks!
 
B

Bob Phillips

In Excel 2003, SUBTOTAL includes special codes, 101 for Average, 102 for
COUNT, etc., these ignore hidden cells
 
Top