If the field contains any text or empty cells, then excel will use "count of"
when creating the summary table.

You'll have to download Debra Dalgleish's addin again:
http://contextures.com/xlPivotAddIn.html

You may want Ron Coderre's addin, too:
http://contextures.com/xlPivotPlayPLUS01.html

Remember that these customizations are now under the Addin's group on the Ribbon
in xl2007.


Joe wrote:

When i am bringing data fields into my pivot table it automatically goes to a
"Count of..." setting. When i had Excel 2003 i had an add-in (pivot power)
that would automatically sum them all so I didnt have to manually adjust
20-30 or more entires every time. Now I have 2007, is there a way to do it or
do I need to d/l an add-in again? If so, what would be a good one to use, I
tried looking but came up empty. Help would be greatly appreciated. thanks.

--

Dave Peterson