formulas calculating results from filters..

[ViktorV]

Hi,

I have a long list of data in sheet one, and a bunch of formulas to calculate stats from that data on sheet two. I have made it so the data in sheet one is a table and have filtered it by date, expecting the formulas to only calculate from the results of that filter, but it calculates from all of the data, disregarding the results of the filter. All my formulas use named ranges. I have been playing around with this for a while now, and can't seem to figure out how to do this...

Can anyone help?

 

[ViktorV]

here is an example of one of the formulas...

=SUMPRODUCT((Winner=$B2)*(Setone=2),--(Settwo<2)*(Match="completed"))

pretty much all the formulas are =sumproducts...