Summarise data based on an unknown combination of conditions


Data on the sheet named “Sales Data Master” shows the Territory wise, Show Title wise and Sales man wise forecast and actual data.  One may want to summarise data based on an unknown combination of conditions.  Conditions may be entered as:

1. All three conditions specified
2. No condition specified
3. Only first condition specified
4. Only second condition specified
5. Only third condition specified
6. First and second condition specified
7. First and third condition specified
8. Second and third condition specified

You may refer to two solution workbooks here

1. Faster because data sheet formulas have been Pasted Special as Values – Download
2. Slower because data sheet formulas are retained – Download

Leave a Comment

Your email address will not be published.