Pivot Tables Count instead of Sum

[Susie]

Quite often when I pivot on data, the output shows "Count
of.." rather than "Sum". This happens even if the table I
am pivoting on is a number format.

I know I can click on the data (in the pivot table wizard)
and change it "sum" but this takes a lot of clicking.
Anyone know how to make this always sum rather than count?

Thanks!

 

[Debra Dalgleish]

You can't change the default setting. 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 each cell in the column contains a number, it should default to Sum.