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.
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
Pivot Table

Pivot tables analyze data without the user needing to enter formulas. Pivot tables also make it easier to manipulate data without performing complex copyandpaste exercises.

Data Field

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

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

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.

References
Resources
 Photo Credit solar calculator image by Springfield Gallery from Fotolia.com