Link to home
Start Free TrialLog in
Avatar of Ladkisson
LadkissonFlag for United States of America

asked on

Modification to the drop down box function

In the attached file I have data that changes with accordance of a needed week – sheet 1 B2.  I’ve already adjusted the source data in the drop down box – I added “All”. Question: how should I modify the formula in Sheet 1 D2 in order to see the sum or “all”? Please refer to the attached file. Thanks!
Lookup.xlsx
Avatar of NBVC
NBVC
Flag of Canada image

Try:

=IF(B$2="All",SUMIF(Sheet2!$A$2:$A$60,A2,Sheet2!$D$2:$D$60),SUMIFS(Sheet2!$D$2:$D$60,Sheet2!$A$2:$A$60,A2,Sheet2!B2:B60,B$2))

copied down
Avatar of Ladkisson

ASKER

I'll try this formula. Thx! I also just sent you a message to the post that I recently accepted. The suggested formula does not work. I started a new question with a different file attached. Since you've been helping me, do you think you could figure out what is wrong with it? Thanks!!
ASKER CERTIFIED SOLUTION
Avatar of NBVC
NBVC
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Thank you for all your help!