If you're using xl2003, you could use =subtotal(). It was enhanced to be able
to ignore those manually hidden rows, too.

pwz wrote:

How to build a conditional sum formula for unhidden rows only (other rows
are hidden manually or by auto-filter)? Thanks in advance!

Regards,
Pat

--

Dave Peterson