pivot table!

V

via135

hi all!

in my pivot table while i am trying to add field names in the data area
i am getting only the "count" and not the "sum". but my target is only
the "sum"?of course..the filed is formatted as number!
what's wrong with me?

help pl?

-via135
 
D

Dave Peterson

If excel puts Count, then that means you have at least one entry in that field
that is text or empty.

When you're building the pivottable, just double click on that "Count of" button
and select Sum.

But if you think all your entries are real numbers (no text, no blank cells),
then you have a problem. Formatting the cell as a number isn't enough to make
the existing value a number.

I'd select an empty cell.
edit|copy
select all the cells in that field/column
edit|paste special|Add.

This should convert the text numbers to number numbers.
 
V

via135

thks Dave!

you have exactly pinpointed my problem! after double clicking the
"countof" and selecting the "sum" option i am able to get the sum of
items!

but one more hurdle..i am having two fields called "Dr" & "Cr"! while i
am trying both the fileds in the data field the pivot table gives me
only the count! but while trying with one field i can select the option
(as per your tip) sum,count,max...etc?

help me pl?

-via135
 
D

Dave Peterson

You should be able to drag the DR field to the data area, then double click and
change it.

Then drag the CR field to that same data area and do the same thing.
 
Top