ExcelBanter - Formula only for visible Cells

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Formula only for visible Cells (https://www.excelbanter.com/excel-discussion-misc-queries/196153-formula-only-visible-cells.html)

lightbulb

Formula only for visible Cells

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

Thanks!

Bob Phillips[_3_]

Formula only for visible Cells

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

--
__________________________________
HTH

Bob

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

Thanks!

All times are GMT +1. The time now is 04:19 AM.