L lightbulb Jul 24, 2008 #1 Is there a way to make a function apply only to visible cells, in otherwords not include a cell if it is hidden? Thanks!
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 Jul 24, 2008 #2 In Excel 2003, SUBTOTAL includes special codes, 101 for Average, 102 for COUNT, etc., these ignore hidden cells
In Excel 2003, SUBTOTAL includes special codes, 101 for Average, 102 for COUNT, etc., these ignore hidden cells
