=SUBTOTAL(109,A1:A8000) will give you what you need.


--
Regards,
Dave


"Paully Shore" wrote:

I have a worksheet with 8000+ rows. Some of the rows are hidden. I want to
have a formula at the bottom of the rows that sums only the visable cells
(non-hidden) rows. Any suggestions? (The rows are hidden and not filtered).
--
Thanks Buuuuddddy!