Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
All 0's for Sums in Pivot Table
I have a large data set which I am trying to summarize. Basically I am
trying to sum the weight of fish caught by site. It shows the counts correctly but everytime I try to switch the calculation to sums, it displays 0 for all of the cells which I know not to be correct. Does anyone know what is going on? I have been trying to figure it out all day. If it helps, I am using Excel 2002. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
All 0's for Sums in Pivot Table
Most likely the weights are seen as text by Excel, go to source code and use
=ISTEXT(A2) replace A2 with the first cell in weight column, copy down, if you get TRUE the values are text, one remedy would be to copy an empty cell, select all the weights and do editpaste special and select add. If that does not work you must have hidden characters in your range. -- Regards, Peo Sjoblom Excel 95 - Excel 2007 Northwest Excel Solutions www.nwexcelsolutions.com "It is a good thing to follow the first law of holes; if you are in one stop digging." Lord Healey "Angela Giuliano" <Angela wrote in message ... I have a large data set which I am trying to summarize. Basically I am trying to sum the weight of fish caught by site. It shows the counts correctly but everytime I try to switch the calculation to sums, it displays 0 for all of the cells which I know not to be correct. Does anyone know what is going on? I have been trying to figure it out all day. If it helps, I am using Excel 2002. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
All 0's for Sums in Pivot Table
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
All 0's for Sums in Pivot Table
Nope. All came up as FALSE. Guess I have the hidden characters option . . .
Any way around that? "Peo Sjoblom" wrote: Most likely the weights are seen as text by Excel, go to source code and use =ISTEXT(A2) replace A2 with the first cell in weight column, copy down, if you get TRUE the values are text, one remedy would be to copy an empty cell, select all the weights and do editpaste special and select add. If that does not work you must have hidden characters in your range. -- Regards, Peo Sjoblom Excel 95 - Excel 2007 Northwest Excel Solutions www.nwexcelsolutions.com "It is a good thing to follow the first law of holes; if you are in one stop digging." Lord Healey "Angela Giuliano" <Angela wrote in message ... I have a large data set which I am trying to summarize. Basically I am trying to sum the weight of fish caught by site. It shows the counts correctly but everytime I try to switch the calculation to sums, it displays 0 for all of the cells which I know not to be correct. Does anyone know what is going on? I have been trying to figure it out all day. If it helps, I am using Excel 2002. |
#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 |
Reply |
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 |