Using sumproduct and an autofiltr

[craig007]

Hi there,
We use a flat file of data results which requires a sumproduct to get the correct daily result for the activities performed.

Am looking for a way for this sumproduct function to work after an auto filter is applied (eg change the cells referenced in the sumproduct formula to reflect the change in the auto filter).

I have attached a sample file.

The top is the result I am looking for when the data is just the single day.

the next section is how the data looks - with the auto filter.

Is there any way to make the sumproduct interact with the results of the auto filter?

Any assistance would be greatly appreciated.

I am sure I have seen it done before I just don't seem to be able to get it to work.