When you add a numeric data field to the Values area in a pivot table, the summary function defaults to either Sum or Count. You can change that field to use one of the other summary functions, such as Average. The Average Function The Average function in a pivot table works like the AVERAGE function [...]

When you add a field to a pivot table’s Values area, Count is the default summary function, if the field contains nonnumeric or blank cells. (If the field’s data are all numbers, Sum is the default function.) The Count function’s name is slightly confusing, because it’s like the COUNTA worksheet function, not the COUNT worksheet [...]

This example is based on the Work Orders workbook, used in my book, "Beginning PivotTables in Excel 2007." If you’re working through the book, this video shows the steps outlined starting on page 46. In the video, we create a pivot table that’s based on a formatted Excel Table. Then, the Values field is changed [...]

When you add a numeric field to the Values area of a pivot table, it usually appears as a Sum. For example, in the pivot table shown below, the Units field became Sum of Units. Occasionally, when you add a numeric field to the Values area, it shows the Count, instead of the Sum. In [...]