Excel Pivot Table Summary Functions | Techy Stuff | Scoop.it
When fields are added to pivot table Values area, the default summary funtion is Sum or Count. Later, you can change to other functions.