G Guest Sep 5, 2007 #1 When I try to add several cells by AutoSum, the only thing that shows in the resulting cell says "SUM(D8:F8)," not a number.
When I try to add several cells by AutoSum, the only thing that shows in the resulting cell says "SUM(D8:F8)," not a number.
G Guest Sep 5, 2007 #2 There has to be an = (or a +) in front of the SUM part otherwise it's treated as text.
G Guest Sep 8, 2007 #3 Until you accept the formula by pressing "Enter", Excel tells you the cells selected, not the value. Press "Enter". www.magicspreadsheets.com
Until you accept the formula by pressing "Enter", Excel tells you the cells selected, not the value. Press "Enter". www.magicspreadsheets.com
