View Single Post
  #1   Report Post  
bucketheaduk
 
Posts: n/a
Default Sum function which ignores hidden rows


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