Thank you so much. How silly of me! I did it the other way round, that is what caused the problem.
Andrew > On 31 May 2025, at 09:16, 'Ian Robinson' via MacVisionaries > <macvisionaries@googlegroups.com> wrote: > > Hi Andrew, > > You need to put the equals sign first to define the cell as having a formula. > =sum(I2:I10) > > HTH. > > Ian > >> On 31 May 2025, at 08:45, 'Andrew' via MacVisionaries >> <macvisionaries@googlegroups.com> wrote: >> >> Hi, >> >> I’ve forgotten how to insert a sum formula into a cell in spreadsheet in >> Numbers. I type: sum=(I2:I100) but all I get is the exact text above but >> not the actual calculation. What am I doing wrong? >> >> Andrew >> >> -- >> 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: >> mk...@ucla.edu and your owner is Cara Quinn - you can reach Cara at >> caraqu...@caraquinn.com >> >> The archives for this list can be searched at: >> http://www.mail-archive.com/macvisionaries@googlegroups.com/ >> --- >> 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 macvisionaries+unsubscr...@googlegroups.com. >> To view this discussion visit >> https://groups.google.com/d/msgid/macvisionaries/26DD2A67-5131-4727-88AD-07CEB67FD595%40me.com. > > -- > 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: > mk...@ucla.edu and your owner is Cara Quinn - you can reach Cara at > caraqu...@caraquinn.com > > The archives for this list can be searched at: > http://www.mail-archive.com/macvisionaries@googlegroups.com/ > --- > 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 macvisionaries+unsubscr...@googlegroups.com. > To view this discussion visit > https://groups.google.com/d/msgid/macvisionaries/4C580635-F318-44F4-A113-66D79447A113%40icloud.com. -- 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: mk...@ucla.edu and your owner is Cara Quinn - you can reach Cara at caraqu...@caraquinn.com The archives for this list can be searched at: http://www.mail-archive.com/macvisionaries@googlegroups.com/ --- 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 macvisionaries+unsubscr...@googlegroups.com. To view this discussion visit https://groups.google.com/d/msgid/macvisionaries/09852FD5-380A-4233-B54A-584CA574E1B3%40me.com.
