Depending upon your needs, there is a Copy of visible only cells, click
Edit, Go To, select Visible Cells, then select the range and paste.
This new range can then be totalled.

Otherwise . . I think it's a little VBA code


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=390100