Pivot Table - Sum not count

  • Thread starter Thread starter Derrick
  • Start date Start date
D

Derrick

I've this problem, when I drag the fields into the "Data"
area, it will show as "Count of Q1 Results". But what I
actually want is "Sum of Q1 Results". I would have to
manually go to field setting and reconfigure from count
to sum.

It happens for all the fields I drag into the "Data"
area. Is there any way around this? Thanks.
 
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.
 
Back
Top