pivot table defaults to count instead pivot table defaults to sum or count pivot table defaults to count instead change count to sum in excel pivot sum values in a pivottable microsoft pivot tables how to change the default change count to sum in excel pivot default function in pivot table change count to sum in excel pivot pivot table defaults to sum or count default function in pivot table pivot table basic count exceljet excel pivot table summary functions sum