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.

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