Expanding on Dave's contribution and provided you have Excel 2003, since
you're looking for a conditional sum formula, you can use something like
the following formula for filtered data...

=SUMPRODUCT(SUBTOTAL(3,OFFSET(CondRange,ROW(CondRa nge)-MIN(ROW(CondRange)
),0,1)),--(CondRange=Criteria),RangeToSum)

For manually hidden rows, change the 3 to 103.

Hope this helps!

In article , "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