Sale report help

[jaspers]

I have a on going sales report that I'm looking to sum the total sales per customer between specific dates. Column A is the date of Sale, Column B is the customer, Column c is the amount. These columns are always getting more data added each month and do not have a set list of customers or dates. I have Drop downs in F1:F3 to select Date range and Customer. I need G4 to display the sales total between the selected date ranges. Any help is appreciated

 

[Joe4]

You should be able to use a SUMIFS formula to sum the values between two dates, and by Customer.
See here for a detailed explanation and examples: Excel SUMIFS date range formula - sum if between two dates