SUMIF only with unhidden rows in Excel 2010

I have a conditional formula which returns the sum from a range of cells

=SUMIF($AB$566:$AB$5432, ">0", $J$566:$J$5432)

The problem is that I need to calculate only unhidden rows.

I've already tried using SUMPRODUCT with SUBTOTAL and OFFSET functions, but the formula returns an error.

=SUBPRODUCT(SUBTOTAL(109, OFFSET($J$566:$J$5432, ROW($J$566:$J$5432) - ROW($J$566),,1)), --($AB$566:$AB$5432 > 0))

Could anyone help me with this? Thanks.