View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] robotman@gmail.com is offline
external usenet poster
 
Posts: 73
Default Count and Sum data in same Pivot table

I'm new to pivot tables.

I wanted to have one pivot table column that counts the entries in a
data column AND another pivot table column that sums the values of the
same data column. Excel doesn't seem to let me put more than one copy
of the column into the data section of the table. I can change it
between count and sum, but i want to show both at the same time.

Any ideas?

Thanks.