Ah yes, functions are good, though sum(value:value) needs both brackets; but good otherwise. And there's usually so many itneresting functions to play with.
RobH. Ps: I'd assume there's a sqrt(), what is the antithesis of that, for powers? or roots? ----- Original Message ----- From: "Kevin Shaw" <tvsound...@gmail.com> To: <macvisionaries@googlegroups.com> Sent: Saturday, December 27, 2014 11:19 PM Subject: Re: how to calculate several cells in a row Two ways: =A1+B1+C1 or =A1+D1+F1 if they’re non-contiguous. Or, =SUMA1:F1) if the block of cells is contiguous. the same will work for columns or an array. Kevin On Dec 27, 2014, at 5:49 PM, Scott Berry <sb356...@gmail.com> wrote: > Hello there again, > > How do I add several cells together in a formula? > > -- > 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 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 macvisionaries+unsubscr...@googlegroups.com. To post to this group, send email to macvisionaries@googlegroups.com. 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 macvisionaries+unsubscr...@googlegroups.com. To post to this group, send email to macvisionaries@googlegroups.com. Visit this group at http://groups.google.com/group/macvisionaries. For more options, visit https://groups.google.com/d/optout.