Look at the =SUBTOTAL() function
In XL 2002 and before, it only ignores rows hidden by a filter, but XL 2003
gives the option to ignore manually hidden rows.


--
HTH

Bob Phillips

"bucketheaduk"
wrote in message
news:bucketheaduk.1wsd6f_1129115114.5725@excelforu m-nospam.com...

Hey

I'm looking for a way to sum rows but ignore the adjacent rows which
are hidden. excel is adding the stuff in the unhide rows (which is
what i want) but also adding the hidden row numbers too (which i don't
want).

cheers for the help.


--
bucketheaduk
------------------------------------------------------------------------
bucketheaduk's Profile:
http://www.excelforum.com/member.php...o&userid=28032
View this thread: http://www.excelforum.com/showthread...hreadid=475352