You would create a formula in cell C4 that uses the sum function. that is, it would some up the contents of B1: b9. this formula would add the contents of cells be one through b9 displaying its value in C4. =Sum(b1:b9) Typed the above formula exactly as shown into cell number see four, or wherever you want the display. It will sum up the contents of column B rows one through nine. The = is a special character that when typed as the first character in a cell, invokes the formula editor. The help system for numbers is very good, although if you don't have experience with spreadsheets you may find is a little confusing at first. I would take my time and wait through the help system looking especially at things like formulas functions cell references and the like. Look at all the examples and just try to tease it out. Sent from my IPhone
> On Dec 9, 2015, at 6:03 PM, Agent086b <[email protected]> wrote: > > Hi all, > I have lost an earlier email telling me how to do this. > I wish to ad a series of numbers in a column like B5 B6 B7 and so on. I wish > the answer to show in C4. How can I do this or better how can I find this out > for myself? > Thanks for any advice. > Max. > > -- > The following information is important for all members of the Mac Visionaries > list. > > If you have any questions or concerns about the running of this list, or if > you feel that a member's post is inappropriate, please contact the owners or > moderators directly rather than posting on the list itself. > > Your Mac Visionaries list moderator is Mark Taylor and your owner is Cara > Quinn - you can reach Cara at [email protected] > > The archives for this list can be searched at: > http://www.mail-archive.com/[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/d/optout. -- The following information is important for all members of the Mac Visionaries list. If you have any questions or concerns about the running of this list, or if you feel that a member's post is inappropriate, please contact the owners or moderators directly rather than posting on the list itself. Your Mac Visionaries list moderator is Mark Taylor and your owner is Cara Quinn - you can reach Cara at [email protected] The archives for this list can be searched at: http://www.mail-archive.com/[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/d/optout.
