G Guest Mar 28, 2006 #1 i am changing data in cell but the sum at bottom of column is not changing even though the cell range is correct
i am changing data in cell but the sum at bottom of column is not changing even though the cell range is correct
G Guest Mar 29, 2006 #2 Check to make sure Automatic Calculations is turned on. Tools --> Options --> Calculations Tab --> Check "Automatic" HTH, Elkar
Check to make sure Automatic Calculations is turned on. Tools --> Options --> Calculations Tab --> Check "Automatic" HTH, Elkar
N Nick Hodge Apr 2, 2006 #3 Or that the cells are nor formatted as text -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England www.nickhodge.co.uk (e-mail address removed)
Or that the cells are nor formatted as text -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England www.nickhodge.co.uk (e-mail address removed)
