I’ll take a stab at this. if you create a header row or a header column in your table and place a text description in that header cell, then you can reference that label in the formula editor to refer to the entire row/column. for example, if you have one header row with contents columnA, columnB, columnC etc across row 1. then you could have a formula tlike =sum(columnA) and that would sum all cells in column a. Tables have header areas with a max of 5 rows, a data area with unspecified number of rows, and a footer area with a max of 5 rows. The header row closest to the data area is used as labels for the data . Also, there can be header columns up to a max of 5, and the column closest to the data area is used as labels for the data rows. So, with a single header column containing labels row 2, row3, row4, etc. You could reference a single data cell with an address of colB,row4 for example. When in the editor, just start typing the name of the row or column header label and it will auto complete for you if possible.
Hope this is what your asking for, I’m a bit tired and not giving my best thought to the question. Hope it gets you started. Also, I highly recommend reading the section on relative and absolute addressing and all other general topics in the numbers help system. reading that and then experimenting with simple formulas will answer more questions for you than you might think. > On Mar 29, 2015, at 6:40 PM, Eileen Misrahi <[email protected]> wrote: > > Hello All, > > I'm in the same boat as Laura, but have applied some of the same principles > that I've used in Excel. What surprised me was that VO announced the header > for each column when in a particular cell. I was wondering how specify the > defined ranges when creating a simple formula. It was difficult to ascertain > the coordinates of the column and row like in Excel. I just opened the > formula dialog list and chose "sum" to get it inserted to tabulate the > column. Any suggestions regarding the above would be appreciated. > > Thanks in advance. > > Best, > Eileen > > Sent from my iPhone > >> On Mar 29, 2015, at 3:18 PM, Eugenia Firth <[email protected]> wrote: >> >> Hi Laura >> If you know how to use Excel, you should know that numbers will except Excel >> files. One of the things you should know right away so that you don't take >> forever to figure it out, is that when you press the = to start your >> formula, the first thing to do is to press the right arrow key. That get you >> in the correct cursor position to start the rest to your formula. >> >> Gigi >> >> Sent from my iPhone >> >>> On Mar 29, 2015, at 3:47 PM, Laura Bratton <[email protected]> wrote: >>> >>> Hi All, >>> Can anyone recommend a good resource for learning how to use numbers? >>> Thank you, >>> Laura >>> >>> -- >>> 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/d/optout. >> >> -- >> 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/d/optout. > > -- > 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/d/optout. -- 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/d/optout.
