software

Why, in pivot tables, do I sometimes get quot;sumquot; and other times
quot;countquot; 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-Proquot;les8quot; wrote:

gt; Why, in pivot tables, do I sometimes get quot;sumquot; and other times
gt; quot;countquot; when putting fields in the data section? I import data
gt; from CSV files, and in one file I am trying to get the sum of
gt; invoices (and I get count) while in another I am trying to get the
gt; sum of purchase orders (and I get sum).
gt;
gt; Thanks for any insights.
gt;
gt;

Ron,
thanks! One less of life's mysteries to keep me up at night.quot;Ron Coderrequot; wrote:

gt; I believe the field defaults to SUM if all referenced cells in that field
gt; contain numbers. It uses COUNT if any of the cells contain blanks or text.
gt;
gt; Does that help?
gt;
gt; ***********
gt; Regards,
gt; Ron
gt;
gt; XL2002, WinXP-Pro
gt;
gt;
gt; quot;les8quot; wrote:
gt;
gt; gt; Why, in pivot tables, do I sometimes get quot;sumquot; and other times
gt; gt; quot;countquot; when putting fields in the data section? I import data
gt; gt; from CSV files, and in one file I am trying to get the sum of
gt; gt; invoices (and I get count) while in another I am trying to get the
gt; gt; sum of purchase orders (and I get sum).
gt; gt;
gt; gt; Thanks for any insights.
gt; gt;
gt; gt;