what is the difference between count and sum in a pivot table?
The Sum function is used by default for numeric value fields you place in your PivotTable, but here's how to choose a different summary function: In the PivotTable, right-click the value field you want to change, and then click Summarize Values By. ... The Count summary function works the same as the COUNTA function.