My OS is Windows XP Home - the Excel prog is part of Office 97. Just started a new Worksheet and cannot get AutoSum to total figures in a column e.g. Box E10 to show total for E2 to E9. Selecting E10 and then clicking "AutoSum", highlighting E2-E9, pressing Enter produces "=SUM(E2:E9)" in Box E10.I confess to being a bit of a novice but have used Excel previously and never had this problem until now. Can someone put me right?
Hi Whisperer and lotvic - thanks for your suggestions but it still won't work. What's really frustrating is this is the 3rd worksheet in this file. Numbers 1 & 2 operate without a problem. Anyway, have switched to 'Works' spreadsheet for the 2005 calculations since this seems to be 'doing the business'