Sumifs based on filtered data

Hello,

I was wondering if someone could help me out with a formula? In the attached file there are two tabs...a Data tab and a Raw Mall Traffic Report. I want the columns B through G summing as they are in the file now. However I would like column H to sum based off of a filter on the Raw Mall Traffic Report. The filtering would take place in column B of the Raw Mall Traffic Report. Once that filter is set to whatever the user wishes I would like column H on the Data tab to only sum the showing amounts based on the set filter. Is this possible? I tried a Sumproduct with a subtotal but not sure I had it right. Any help is greatly appreciated. Also the report can grow each month adding more rows on the Raw Mall Traffic Report. The report is showing traffic counts by camera by day.

I think I got it working....

=SUMPRODUCT(SUBTOTAL(3,OFFSET('Raw Mall Traffic Report'!$D4:$D50000,ROW('Raw Mall Traffic Report'!$D4:$D50000)-MIN(ROW('Raw Mall Traffic Report'!$D4:$D50000)),,1)),('Raw Mall Traffic Report'!$D4:$D50000)*(('Raw Mall Traffic Report'!$E4:$E50000=A3)))