Sum values based on multiple drop-down lists

[goncalogera]

Hi there,

I'll try my best to explain my problem:

I have a sheet (2020) where daily sales are recorded with date, product, amount,..., salesperson and in another sheet I've created kind of a report with the SUM values (row "Real") to compare actual sales and data with the projected ones. I´ve also added 3 dependent drop down list for Product, Salesperson and Date which are all linked meaning if a specific product is selected then only the salesperson and dates off that product appear. My problem now is that I want the SUM values to change according to the multiple drop-down values selected. I´ve attached a picture that I hope might help in understanding my problem. Sorry that all names are in portuguese!

Thanks in advance!