ExcelBanter - Do not calculate hidden cells

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

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

- - Do not calculate hidden cells (https://www.excelbanter.com/excel-discussion-misc-queries/64399-do-not-calculate-hidden-cells.html)

Gee

Do not calculate hidden cells

How do I leave out te value of a hidden row and not include it in my formula?

Niek Otten

Do not calculate hidden cells

Select all the cells. EditGo To, click Special, check Visible cells only
InsertNameDefine, let's say "HalfRange"
=SUM(HalfRange)

--
Kind regards,

Niek Otten

"Gee" wrote in message
...
How do I leave out te value of a hidden row and not include it in my
formula?

Gary''s Student

Do not calculate hidden cells

Revise the formula tonot use the hidden cells
--
Gary's Student

"Gee" wrote:

How do I leave out te value of a hidden row and not include it in my formula?

Gee

Do not calculate hidden cells

Excellent!!! Thanks very much!

"Niek Otten" wrote:

Select all the cells. EditGo To, click Special, check Visible cells only
InsertNameDefine, let's say "HalfRange"
=SUM(HalfRange)

--
Kind regards,

Niek Otten

"Gee" wrote in message
...
How do I leave out te value of a hidden row and not include it in my
formula?

All times are GMT +1. The time now is 02:17 AM.