How to set Excels pivot data as default SUM instead of COUNT
 

How to set Excels pivot data as default SUM instead of COUNT
 

Hi Pela

The way the PT works, is if the column of data is numeric, then it defaults
to Sum.
If the data is Text (or a numeric column has Text within it or blank cells),
then it defaults to Count.
Therefore, if you set your data range for the PT to be larger than your
existing data, to allow for future entries) you will always get the PT
defaulting to Count.

If you are using XL2007, then it is best to use Insert tabTable then use
the table as the source for the PT.
If you are using XL2003, then use DataList and Create the PT from the List
created.
Both Table and List are Dynamic, and will grow as you add more rows of data.

If you are using XL2002 or earlier, then create your own Dynamic Named
ranges to use as a source for your PT.
There is more information on how to do this here
http://www.contextures.com/xlNames03.html
including a macro to automatically generate dynamic ranges.
--
Regards
Roger Govier

"Pela" wrote in message
...