Tags: DSUM

Summarise data with multiple wildcard OR conditions

{ 0 Comments }

Imagine a dataset as shown below Status Text Number Active bat 1 Passive erq 2 Passive cat 3 Active enm 4 Active dog 5 Suppose the data is in range A3:C7 (headings are in A2:C2).  The objective is to add numbers where the following conditions are met: 1. Status should be Active; and 2. Text […]

Read More →

Summarise data based on an unknown combination of conditions

{ 0 Comments }

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 […]

Read More →