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

Easy bullets in Excel
If you have a numeric keypad, press Alt+7 on numeric keypad to type a bullet in Excel.

Watch MrExcel Video

Forum statistics

Threads
1,118,305
Messages
5,571,445
Members
412,393
Latest member
JayD
Top