Sum vs. Count in Pivot Tables

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Why, in pivot tables, do I sometimes get "sum" and other times
"count" when putting fields in the data section? I import data
from CSV files, and in one file I am trying to get the sum of
invoices (and I get count) while in another I am trying to get the
sum of purchase orders (and I get sum).

Thanks for any insights.
 
I believe the field defaults to SUM if all referenced cells in that field
contain numbers. It uses COUNT if any of the cells contain blanks or text.

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro
 

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

Pivot Table Calculated Field - Sum/count 1
Pivot (Data Items "Count" vs "Sum") 2
Pivot Table Help 1
Pivot Table 1
default pivot tabel from count to sum 1
Pivot Table not summing 2
sorting data in pivot table 2
Pivot table calculated field Count(field) / sum(field) 0

Back
Top