Hi

I have a spreadsheet which is used to track the number of days a customer has paid for.

For example, a customer has bought 10 engineer days from our company. I input how many days we predicted were needed to complete theirproject and how many actual days were required.

At the moment I use a formula which allows me to enter a start date and end date and pulls out the total sum of all days in that date range.

=SUMIFS($E$8:$E$101,$B$8:$B$101,">="&C4,$B$8:$B$101,"<="&C5)

Sample Spreadsheet: test.xlsx

What I now need to do is add a drop down list in Cell C3 which will filter my results based on the customer name entered. So if choose customer ABC from a drop down list, then the data displayed will be changed to reflect this.

I have looked at VLOOKUP and Data Tables, but don't seem to be getting anywhere. New to working with formulas in Excel, your advice is appreciated.

Thanks!
Carl