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.
- Photo Credit solar calculator image by Springfield Gallery from Fotolia.com
How to Count Entries on a Pivot Table
Pivot tables are spreadsheet tools used to summarize a larger data table into a smaller one. In Excel, the default is to...
The Difference in Sum Vs. Count in Excel
The "Sum" and "Count" functions in Excel offer two different ways of looking at the numbers in your spreadsheet. If you use...
How Do I Count Distinct Records in an Excel Pivot Table?
Microsoft Excel is a powerful spreadsheet software program that is often used to compile and manipulate large amounts of data. Excel offers...
How Do I Use Pivot Table in Excel?
How to Change From Sum to Count in a Pivot Table. A PivotTable report is a way to combine and compare large...
How to Take the Label "Sum of" Out of a Pivot Table
When you add fields to the body of your Microsoft Excel 2010 PivotTables, Excel gives them a label of "Sum of X"...
How to Create an Excel Pivot Table
PivotTables are one of the most powerful Microsoft Excel 2010 tools available. They allow you to understand and spot trends in even...
What is a Pivot Table in SQL?
In SQL, a pivot table is a set of data that is transformed from a collection of separate rows to a collection...
How to Add a Calculated Field in a Pivot Table
You can manipulate and display data in many different ways using a pivot table. Since your table changes shape and size when...