In the pivot table, double-click on the Count of Value button at the top
left.
Under Summarize by, choose Sum, then click OK

K.R wrote:
I am trying to use the pivot table function on data from multiple worksheets
in the same workbook.
I selected "multiple consolidation ranges" when prompted for location of
data to be analysed.
I then chose data from 12 sheets having the same column headings (different
# of rows) and created the pivot table.
The problem is, the pivot table created shows the correct columns but shows
the count of values in these columns for each sheet.
I am trying to get the sum of values in each sheet.

Is this possible?





--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html