View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Cathy H Cathy H is offline
external usenet poster
 
Posts: 2
Default Pivot tables - how do I change default from "count of" to "sum

Oh, that's not good news. I have 2,000 columns of data, by 90 rows, and I
want to sum the columns by each row.

The data values *are* numeric, but are calculated with an "IF" statement:
if value A (a date) is greater than value B (a date), the cell value is set
equal to a calculated numeric value between zero and one, else the cell value
is zero.

I made sure I set the formats of all the cells to "numeric, 2 decimals".
The Pivot table still defaults to "count of". (I am not displaying zero
values in my source data, however, if that makes a difference).

Any additional ideas?

- Cathy

"Debra Dalgleish" wrote:

In a pivot table, you can't change the default function. If there are
blank cells, or cells with text, in the column, Excel will default to
the Count function when the field is added to the data area.

If the column contains only numbers, it should default to Sum.


Cathy H wrote:
Excel 2003:
I have a large amount of data going into a pivot table (i.e. 90 entries).
When I drag to the data area, the rows default to "count of" data item 1,
data item 2, ... data item 90.

I then have to select each one individually and change the field settings to
use "sum of" instead of "count of".

How can I set the default to be "sum of"? Or how can I select all 90 rows
and with one choice change them to be "sum of"?

Thank you!



--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html
Blog: http://blog.contextures.com