I think probably your real data file has numbers stored as text. Changing the data source of the pivot table in your example to use Sheet2 data results in values for the SUM fields.