Sum values based on multiple drop-down lists

goncalogera

New Member
Joined
Nov 10, 2020
Messages
14
Office Version
  1. 2019
Platform
  1. Windows
  2. Mobile
  3. Web
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!

1605197304798.png


Thanks in advance!
 

Some videos you may like

Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.

Watch MrExcel Video

Forum statistics

Threads
1,119,116
Messages
5,576,194
Members
412,705
Latest member
Collie
Top