Hi Chirs,

Pivot tables do take a bit of getting used to.

In the data field...if you right click and select "Field Settings" you can
change how the data is analysed.





chrisnichols87 wrote:
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

--
--------------------
Simon - UK

Email at simon22mports [ a t ] hot mail [ d ot ]com

Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200611/1