count function in pivot table
I've imported numeric data into Excel 2007 from a csv file, when i add this data to the data area of a 2007 pivot table, the function defaults to COUNT, I really need it to SUM. I know that you can change the function but can't understand why it's defaulting
to COUNT. Is it something to do with the imported data?
Anwsers to the Problem count function in pivot table
Pivot Table Data Crunching for Microsoft Office EXCEL 2007 by Jelen / Alexander page 292 states:-
“My Pivot Table always uses Count instead of Sum
You have a column in your data source that contains numbers.
Furthermore, you have explicitly formatted that column to be a number field.
Nevertheless, each time you try to add it to your Pivot Table EXCEL automatically tries to use Count on the field instead of Sum.
This leaves you manually changing the calculation method to Sum.
If there are any text values in a source column EXCEL automatically applies Count to the data field for that column.
Similarly even one blank cell causes EXCEL to apply Count.
It is likely that in your source column you have either a text value or a blank.
To alleviate this problem simply remove both text and blank values from the source column and refresh the Pivot Table.”
If my comments have helped please hit Yes.
Open Action Center by clicking the Start button Picture of the Start button, clicking Control Panel, and then, under System and Security, clicking Review your computer's status.
Make sure your computer has at least the minimum amount of random access memory (RAM) required to run the program that is displaying the error. Look for the program requirements online or in the packaging information.
Another Safe way to Fix the Problem: count function in pivot table:
How to Fix count function in pivot table with SmartPCFixer?
1. Click the button to download SmartPCFixer . Install it on your system. Open it, and it will perform a scan for your computer. The junk files will be shown in the scan result.
2. After the scan is finished, you can see the errors and problems need to be fixed. Click Fix All.
3. When the Fixing part is finished, your computer has been speeded up and the errors have been removed
Related: How Can You Update & Download NVidia 6100, 6800 GS/XT Display Driver v.260.89 WHQL,Where to Download NVidia GeForce 8800 GT WHQL-certified driver v.196.21,How to Update & Download NVidia GeForce Go 7400 Display Driver v.260.19.12,[Solved] Download NVidia GeForce GTX 460M Driver v.331.82,Download NVidia Quadro Plex Model IV VGA Driver v.304.43 Certified,Way to Download RealTek RTL8100C(L) Driver v.5.01,Way to Download RealTek RTL8100E Drivers v.694,Way to Update & Download RealTek RTL8101L Auto Installation Program v.6.110 driver,Method to Update & Download RealTek RTL8111G PXE and RPL ROM code v.2.58 driver,How to Update & Download RealTek RTL8411B(N) Driver v.10.003,Best Way to Update & Download ASUS A53SV nVidia Graphics Driver v.18.104.22.16886,Method to Herunterladen ASUS K75VJ Intel Rapid Storage Technology Treiber v.22.214.171.1240,How Can You Update & Download ASUS CG8580 Intel Chipset Driver v.126.96.36.1999,Method to Update & Download ASUS K41VD Intel INF Update Driver v.188.8.131.525,Way to Update & Download ASUS Pro70T NB Probe v.3.0.0026 driver
Read More: How Can I Fix - convert year month(TEXT) into sortable Date Format?,[Anwsered] Convert a table into a list,Troubleshoot:Convert numbers to date and time,Solution to Error: count the number of tabs in an excel book,How to Resolve - cursor and page move automaticly, ctrl button stops it temporarily?,Closing Internet Explorer causes error,Compare 2 Tables and Calculate the PROFIT Faster,Computer goes to Windows Boot Manager after Start,Connect to one of my network computer remotely when don't allow exception box Marked,computer locking up randomly