The sum function is simply one of potentially many terms in an arithmetic expression. All you would need to do here is to tack/60 at the end of the formula after the closing parenthesis for the sum function. That would look like the following Sum(B5:B30)/60 Now it has become a two-term arithmetic expression with the terms separated by one arithmetic operator, the slash.
Sent from my IPhone > On Dec 22, 2015, at 9:35 PM, Agent086b <agent0...@internode.on.net> wrote: > > Hi all, > thanks for the help recently I have been able to get some formulas working in > numbers. I have taken a look at some of the help but can not find the answer > to this problem. > I am adding up some numbers with the following. SUM((B5:B30)) this works > well. > The total shows up in C5 where I entered the formula. I wish to ad to the > formula by dividing the total by 60. Do I need to ad another ( ) with /60 > between. > 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 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 post to this group, send email to macvisionaries@googlegroups.com. > 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 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 post to this group, send email to macvisionaries@googlegroups.com. Visit this group at https://groups.google.com/group/macvisionaries. For more options, visit https://groups.google.com/d/optout.
