sumproduct using a filter

I tried to utilize the solutions shown here but to no avail.
http://excelforum.com/showthread.php?t=593049

my current formula is =SUMPRODUCT($W2:$W138,H2:H138)

I have 9 buttons assigned to macros to filter in various ways.
They may filter based on Column E or Column F

   Selection.AutoFilter Field:=5
    Selection.AutoFilter Field:=6, Criteria1:="=up*", Operator:=xlOr, _
        Criteria2:="=no previous*"

or

    Selection.AutoFilter Field:=6
    Selection.AutoFilter Field:=5, Criteria1:="=up*", Operator:=xlOr, _
        Criteria2:="=no previous*"

I would like my SUMPRODUCT to calulate only the filtered data.
is it possible?

That's another one I tried to apply, but
I don't see how it can work, because I'm not Subtotalling Column H, I'm subtotalling the SUMPRODUCT of H * W .
but then only on the visible cells

I tried to reduce the file as small as I could to still give you the general idea.
Click any of the buttons at the top to filter.
Thanks