pivot tables-data field formatting

  • Thread starter Thread starter Guest
  • Start date Start date
I don't think you can.

If all the entries are numeric, you'll get Sum, but if any are text (or empty),
you get count.
 
All of my entires are numeric, but my default settings do not give me Sum,
they default and give me "Count". I have to change each to Sum.
 
I'd double check--maybe you have an extra row in your pivottable source range.

Maybe you have a cell formatted as text masquerading as a number.

If you select the cells and right click on the statusbar in the bottom right
corner, you can choose Count Nums and Count.

Are those the same quantity?

And do they match the number of cells in the selection? (empty cells cause
trouble.)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Changing Default Function in Pivot Tables 1
Using text values in Pivot Tables 5
Pivot Table Calculated Field - Sum/count 1
Pivot (Data Items "Count" vs "Sum") 2
Create Pivot Table Data with Column "Sum" rather than "count" defa 2
pivot table data field defaults to COUNT, would like it to default toSUM 2
Pivot Table Formula Problem 1
Pivot table - value field settings - default? 2

Back
Top