I've got a slight problem. I want to select every cell in the two
columns when creating a pivot table. When doing this however, the
following is produced:


Count of 0
AA Total
AA 1
DD 2
HH 1
TT 2
(blank)
Grand Total 6



and not:



Sum of 0
AA Total
AA 78
DD 7
HH 7
TT 11
Grand Total 103


Any idea how I can do this?

Cheers,

Chris