Must be something different when you set up that worksheet. Sent from my iPad
> On Feb 16, 2015, at 11:14 AM, Anne Cartwright <[email protected]> wrote: > > 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 _______________________________________________ MacGroup mailing list [email protected] http://www.math.louisville.edu/mailman/listinfo/macgroup
