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?