# Data analysis – subtotals

## Subtotals

One of the simplest ways to summarise worksheet data is to add subtotals.

Example: An analyst is interested in the sales data shown in figure 1, worksheet(1) named Sales Data 1.

This data set is constructed as follows:- row 1 is the header or labels row, and describes the fields in each column. This text data has some labels containing space characters. For example, worksheet column A is labeled Invoice No. The numbers 150100, 150101, 150102, ... are in the Invoice No fields. There are 11 fields in total. Each row in the body of the data is one unique record. Some blank or empty empty cells are OK, but there should be no empty rows or columns in the data set. When you click in a cell within the data, the data set becomes the Current Region.