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