Pivot Table in Excel

[Dinesh]

Dear Expert,

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

[email protected]

 

[Debra Dalgleish]

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

 

[Dinesh]

Thanks Debra.

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