I get the similar incorrect results: that is an attempt to fill right and in this case (clicking on a blank cell) with an error message that a formula can't reference its own cell (=SUM(D43:E43)).
If I set up a new SS and use your method or mine , I get the correct results. Anne On Feb 16, 2015, at 3:20 PM, Tom <[email protected]> wrote: > Aloha > Using numbers, I just click on any empty cell in column ant use functions-sum > and it works every time. U don't need to highlight > Tom > > Sent from my iPad > >> On Feb 16, 2015, at 8:47 AM, Anne Cartwright <[email protected]> wrote: >> >> I have many spreadsheets in Numbers and on a couple of them when I go to add >> a column using the Function drop down menu at the top, a new column is added >> and it is populated with 0s. If I click on one of the cells with the 0 I get >> "=SUM (E42:E:42). >> >> Why is it filling left? Or better yet, how do I get it to stop and just add >> the column. note: I first highlight the column and then go to the Function >> drop down menu and then Sum. The cell below the highlighted column is blank. >> >> Numbers '09 version 2.3 (554) inMac OS X 10.8.5. >> >> Anne _______________________________________________ MacGroup mailing list [email protected] http://www.math.louisville.edu/mailman/listinfo/macgroup
