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?