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?
|