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
Bookmarks