Some of your cells look like numbers but are actually text. There are
instructions here for converting those to real numbers:

http://www.contextures.com/xlDataEntry03.html

After you fix the numbers, refresh the pivot table and the sum should be
correct.

RedFive wrote:
I have created a PivotTable using data in another spreadsheet. For some
reason when I try to sum the data in the Data Field, all the values turn to
zeros. But if I leave it as a count the information is correct. Is it
because the data in the original cells are formulas? Any help or
suggestions would be greatly appreciated. Thanks


--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html
Blog: http://blog.contextures.com