— The Excel file related to this challenge can be downloaded from Challenge – Multiple OR Conditions —
Given your data below, you need to find the total sales for cities given in F1 to I1 and zones given in F2 to I2. Either city has to match in F1 to I1 or zone should match in F2 to I2. If both city and zone match, it should be considered once only not twice.
Seattle East 20
Seatltle West 10
Miami East 30
Denver South 50
The answer for above for Seattle and East should be 20+10+30 = 60 not 20+20+10+30 = 80
You may post your answer in comments section.
Note – Solution to this challenge will be published after 1 month i.e. on 25-Oct-15.