Count Vs. Sum in a Pivot Table
Both Microsoft Access and Microsoft Excel use PivotTable reports to analyze and summarize large amounts of organized data. Two of the functions available with pivot table data fields are COUNT and SUM. Both functions add data values, but operate on different types of data values.
Microsoft Access and Microsoft Excel
Microsoft Access and Microsoft Excel provide users with a way of storing data. Microsoft Access organizes data using databases. Microsoft Excel stores data in spreadsheets.
Pivot tables analyze data without the user needing to enter formulas. Pivot tables also make it easier to manipulate data without performing complex copy-and-paste exercises.
A data field in the pivot table contains values from the original data used to create the pivot table. The data field contains the data on which pivot tables perform operations such as SUM and COUNT.
SUM is the default operation used to add numerical data in a pivot table. A data field containing the values 1, 2, 3, 4 and 5 would sum to 15.
COUNT is the default operation performed on all other data types in a pivot table. A data field containing red, blue, red, yellow and green would return the values of 2 for the count of red, 1 for the count of blue, 1 for the count of yellow and 1 for the count of green. COUNT is also the operation used to add up the number of entries in a data field. A data field containing the values 1, 2, 3, 4 and 5 would return 5 for the count of data values.