I would like a formula to extract data based on 3 conditions (data validation conditions) if an item is selected from any of the data validation drop down option. Desired outcome is in green color.
I have attached a sample Excel file for your convenience.
Thanks in advance.
Last edited by bjnockle; 06-01-2014 at 10:45 AM.
Use this formula in K6
Copy formula down and across.
=SUMIFS(E$3:E$26,$B$3:$B$26,$J6,$C$3:$C$26,$J$3,$D$3:$D$26,$K$3)
or
=SUMPRODUCT(($B$3:$B$26=$J6)*($C$3:$C$26=$J$3)*($D$3:$D$26=$K$3)*(E$3:E$26))
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
AlKey: thanks for the suggested formula for the target criteria. It works great. I would like a column J to change (product list) when either West or East is selected from the drop down option.
Thanks
It will change. I think the reason you don't see it is because Product 1, 2 and 5 are not listed with East criteria. If you create a validation list for all listed Products then you should be able to see all of the results.
Please see attached file. I also added a formula that will populate Product list based on the selection in cell J3. I think this is what your were asking?
Alkey: Thank you - the suggested formula works like a charm. You are a genius!
You're welcome and thank you for the feedback!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks