R
Roger Govier
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 tab>Table then use
the table as the source for the PT.
If you are using XL2003, then use Data>List 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.
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 tab>Table then use
the table as the source for the PT.
If you are using XL2003, then use Data>List 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.