Using Sumifs on filtered range

[greatcookies]

I have a sheet that has sales data from 2015-2017 listed by day. What I would like to do is filter the data and then pull out data for each day within the filtered data. I don't think Sumifs will work since it looks at the entire range. I have read that subtotal would work, just not sure how to go about writing the formula.

Let's say I have a table named AllData with the data I would like to extract in column F and the day of the week in column E.

Can someone get me started on writing this formula? Any help is much appreciated.

Thank you!

 

[Trebor76]

Hi there,

You need to use two functions - SUMPRODUCT and SUBTOTAL. See here for how it's done.

HTH

Robert

 

[greatcookies]

Thank you! I think I got it figured out from the post you referred me to.

I appreciate your help!