Formula to Sum & Count the Visible numbers

Hi,
Can someone help me out with a couple formula's

I Need some help to count all the "YES" in a column that are visible.

Somthing along the lines of:

Please Login or Register  to view this content.

The problem with the formula above it counts the "NO" as well.

I also need a formula to sum up the numbers in column (M20:50000) if the Column(L20:L50000) Has a "YES") and are visible.

Thanks for any help, Mike

Have a look here: http://www.contextures.com/xlFunctions04.html#Visible

Dom

These would be the formula:

=SUMPRODUCT(SUBTOTAL(3,OFFSET(L20:L50000,ROW(L20:L50000)-MIN(ROW(L20:L50000)),,1)), --(L20:L50000="Yes"))

=SUMPRODUCT(SUBTOTAL(3,OFFSET(L20:L50000,ROW(L20:L50000)-MIN(ROW(L20:L50000)),,1)), --(L20:L50000="Yes"),(M20:M50000))

Dom