I'm transforming multiple excel sheets into a single sheet using pivot
tables. There are frequently multiple items in the data column which appear
as 'count of'. Is there a simple way to get all the entries to be 'sum of'
instead of doing each one manually?-we're talking about 100 items
occasionally!

Oh, and if you can answer this without using code, I'd appreciate it, Cheers
now, Rob.