I couldn't figure it out. Copied all and pasted into a new Numbers SS and it works just fine.
Oh well. Thanks all for the suggestions. Anne On Feb 16, 2015, at 7:39 PM, Tom <[email protected]> wrote: > 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
