View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
les8
 
Posts: n/a
Default Sum vs. Count in Pivot Tables

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.