Pivot table_How to change default summary function from Count to Sum?

J

Julia

Does anybody know how to change default summary -
typically it is "Count", most of the time I need "Sum". I
mean, not manually double clicking every button in data
field, but automatically - I have up to 30-35 variables at
times. Hypothetically it also possible by filling all
blank cells with zeroes, so that Excel "understands" it's
numerical. I am working with large spreadsheets and I am
not able to fill every cell. Is there other way?

thanks,

Julia
 
D

Debra Dalgleish

You can't change the defaults. If there are blank cells, or cells with
text, in the column, Excel will default to the Count function when the
field is added to the data area.

If the column contains only numbers, it should default to Sum.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

default pivot tabel from count to sum 1
Create Pivot Table Data with Column "Sum" rather than "count" defa 2
Sum multiple worksheets and summary tab that would sum and count by rep name 0
Pivot Table Default - Count to Sum 1
Sum multiple worksheets and summary tab that would sum and count by rep name 0
Changing Default Function in Pivot Tables 1
SUM & OFFSET & PIVOT TABLE?? 0
Default values for cell formatting and Pivot tables 1

Top