Pivot tables are spreadsheet tools used to summarize a larger data table into a smaller one. In Excel, the default is to sum the data in each requested field combination. Suppose that you would rather count the frequency of data in a field combination instead of sum the numbers. Pivot tables allow you to do this for both discrete and grouped continuous data. You can count the number of times a certain value appears in the data, and even count frequency of occurrence within user-defined ranges. Writer Bio
