| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
All 0's for Sums in Pivot Table
Thank you! That worked!!!
"CaptainQuattro" wrote: Could it be that your source data looks like numbers but is actually a collection of text strings? Try the following: Right-click on the area below your spreadsheet where it says "Ready" and make sure that "Sum" is checked on the pop-up menu that appears. Select a few of the numbers in your data that you want to sum, and see if the sum appears on the right, below your spreadsheet. If not, you need to convert strings to numbers as follows: Select the column that contains your numbers. Click Data Text to Columns Next Next General Finish -- CaptainQuattro ------------------------------------------------------------------------ CaptainQuattro's Profile: http://www.excelforum.com/member.php...o&userid=32763 View this thread: http://www.excelforum.com/showthread...hreadid=544938 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Derived Columns in Pivot Table | Excel Discussion (Misc queries) | |||
| Linking to a pivot table from a formatted invoice | Links and Linking in Excel | |||
| Using a Pivot Table Calculated Field to get a Unique Count | Excel Worksheet Functions | |||
| Pivot -- want to use Max and Sum in same table | Excel Worksheet Functions | |||
| how to delete/clean out the row list in pivot table | Excel Worksheet Functions | |||
Threaded Mode
