software

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

Select all the cells. Editgt;Go To, click Special, check Visible cells only
Insertgt;Namegt;Define, let's say quot;HalfRangequot;
=SUM(HalfRange)

--
Kind regards,

Niek Otten

quot;Geequot; gt; wrote in message
...
gt; How do I leave out te value of a hidden row and not include it in my
gt; formula?
Revise the formula tonot use the hidden cells
--
Gary's Studentquot;Geequot; wrote:

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

Excellent!!! Thanks very much!

quot;Niek Ottenquot; wrote:

gt; Select all the cells. Editgt;Go To, click Special, check Visible cells only
gt; Insertgt;Namegt;Define, let's say quot;HalfRangequot;
gt; =SUM(HalfRange)
gt;
gt; --
gt; Kind regards,
gt;
gt; Niek Otten
gt;
gt; quot;Geequot; gt; wrote in message
gt; ...
gt; gt; How do I leave out te value of a hidden row and not include it in my
gt; gt; formula?
gt;
gt;
gt;