Pivot Table - Sum not count

[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.

 

[Debra Dalgleish]

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.