The formula should be: =sum(A1:A4)
You don’t have the equal sign and are missing the brackets surrounding the expression. Jeff > On Jul 9, 2018, at 6:49 AM, 'Adrienne Chalmers' via MacVisionaries > <[email protected]> wrote: > > I am a total novice in relation to spreadsheets as a whole, but I am trying > to teach myself how to use Numbers. > > I have worked out how to add all the values in a column, but I need to work > out how to add selected rows in one column. I realise I need to put a formula > in the cell in which I wish the result to appear, but I can’t seem to get it > to work. I’m clearly doing something stupid. > > If, for example, I want to add the numbers in rows A1 to A4 and have the > result appear in B5, exactly how do I do that? I had a stab at SUM A1:A4, but > nothing happened when I typed that into B5. Clearly I am missing out a step, > or I have got the formula wrong, or both. Any ideas? > > Thanks in anticipation > > Adrienne > > -- > 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. You can reach mark at: > [email protected] 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 https://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. You can reach mark at: [email protected] 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 https://groups.google.com/group/macvisionaries. For more options, visit https://groups.google.com/d/optout.
