Hi, If I'm understanding you correct, then the Fill Down command is what you need.
• Let's say you have some data in B2, C2, D2 and E2 and you wish them added together and the total placed in F2. • enter =sum(b2:e2) in F2. Or, highlight B2 through E2 then up to the Insert menu, down to Functions and choose Sum. The Sum function and result will be placed in F2 automatically with the same syntax as I first mentioned. • Now, if you have data going down in multiple rows within columns b, c, d, and e and wish them to be each totalled in column f, then simply go to f2 (your initial total, and hold down the shift key, then arrow down to the last row of data. VO should say something to the effect of x number of rows selected. • Up to the Insert menu again, down to Fill and choose Down from the sub-menu. All the cells below your initial cell of f2 will be given the same formula as f2 but they will be filled relative to the corresponding row. So, in f12, it would be the sum of b12 through e12. • If you place a total down in row 50, for example, and you wish to add some more rows, simply navigate to the last cell before the total, press option-down arrow to add a row below. The total will move down and its formula will be modified accordingly. If it is just one row that you've added, then you could copy and paste from the last cell above to maintain the formula or use the Fill Down from the last cell above instead. You may also wish to know that the Header Row and Header Column are not set in stone. Under the Table menu, you can set the number of Header rows and columns. Be careful though to not remove Header rows or columns when you have data or titles within them as they will be removed as well. Hope this was the sort of thing that you were looking for. Later... Tim Kilburn Fort McMurray, AB Canada On 2013-10-08, at 5:30 PM, Alex Hall <[email protected]> wrote: > If that's the case, how do I add a formula to a cell but keep the cell label? > > For the second part, what I want is for each row of column 14 to be > automatically filled in using the values of three other columns in that row. > Specifying, say, g2+h2 will not work for l3, I'd need g3+h3. There has to be > a way to generalize this for a whole column... > On Oct 8, 2013, at 11:47 AM, Tim Kilburn <[email protected]> wrote: > >> Hi, >> >> When focus is on a specific cell and you are entering data into that cell, >> you are actually entering the data into the Formula field. This is normal >> Spreadsheet behaviour. The entry field is actually separate from the cell >> itself. This is how you can know both the result of a given formula and the >> formula itself for each cell. >> >> I'm not sure what you're asking for the second question. Are you trying to >> put all three entries from columns 7, 8 and 10 into 14? Are you wanting >> some function to be performed? Sorry, I'm not getting it. >> >> Later... >> >> Tim Kilburn >> Fort McMurray, AB Canada >> >> On 2013-10-08, at 9:28 AM, Alex Hall <[email protected]> wrote: >> >>> Hi again, and sorry for all the questions about Numbers. I'm trying to add >>> a formula to a column, a simple subtraction of three other columns. When I >>> hit equals, I can type my formula, but then the title I gave the column is >>> gone (I pressed equals on the header cell of the column). If I stop >>> interacting a few times I can find a formula area; how is this different >>> from what happens when I press equals? Which should I use? On a side note, >>> what's the syntax for using only columns? That is, any entry in column 14 >>> should be auto-filled by the entries in columns 7, 8, and 10 for every row, >>> so absolute cell coordinates won't work. >>> >>> >>> Have a great day, >>> Alex (msg sent from Mac Mini) >>> [email protected] >>> >>> >>> >>> -- >>> You received this message because you are subscribed to the Google Groups >>> "MacVisionaries" group. >>> To unsubscribe from this group and stop receiving emails from it, send an >>> email to [email protected]. >>> To post to this group, send email to [email protected]. >>> Visit this group at http://groups.google.com/group/macvisionaries. >>> For more options, visit https://groups.google.com/groups/opt_out. >> >> >> -- >> You received this message because you are subscribed to the Google Groups >> "MacVisionaries" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to [email protected]. >> To post to this group, send email to [email protected]. >> Visit this group at http://groups.google.com/group/macvisionaries. >> For more options, visit https://groups.google.com/groups/opt_out. > > > > Have a great day, > Alex (msg sent from Mac Mini) > [email protected] > > > > > -- > You received this message because you are subscribed to the Google Groups > "MacVisionaries" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To post to this group, send email to [email protected]. > Visit this group at http://groups.google.com/group/macvisionaries. > For more options, visit https://groups.google.com/groups/opt_out. -- You received this message because you are subscribed to the Google Groups "MacVisionaries" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/macvisionaries. For more options, visit https://groups.google.com/groups/opt_out.
