Dear Expert,

How do I get my data add up as "SUM" instead of "COUNT" in Pivot Table for
all Columns that I add.

You can't change the default settings for the data fields. If a field
contains blank cells, or cells with text, it will default to COUNT.
Otherwise, it will SUM.

To change the operation for a field, in the layout window, double-click
on the data field button, and choose to Summarize by Sum, instead of Count.


Dinesh wrote:
How do I get my data add up as "SUM" instead of "COUNT" in Pivot Table for
all Columns that I add.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Thanks Debra.

"Debra Dalgleish" wrote:

You can't change the default settings for the data fields. If a field
contains blank cells, or cells with text, it will default to COUNT.
Otherwise, it will SUM.

To change the operation for a field, in the layout window, double-click
on the data field button, and choose to Summarize by Sum, instead of Count.


Dinesh wrote:
How do I get my data add up as "SUM" instead of "COUNT" in Pivot Table for
all Columns that I add.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html