Re: how to calculate several cells in a row
From previous solution:- =a1+b2+c3+h44 Rh, guessing, but same as last suggestion. I used to like playing with SS's a long time ago. - Original Message - From: Scott Berry sb356...@gmail.com To: macvisionaries macvisionaries@googlegroups.com Sent: Saturday, December 27, 2014 10:49 PM Subject: how to calculate several cells in a row 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.
Re: how to calculate several cells in a row
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.
Re: how to calculate several cells in a row
Quite so, but guess they got it now. - Original Message - From: Yolanda ylt...@gmail.com To: macvisionaries@googlegroups.com Sent: Saturday, December 27, 2014 11:27 PM Subject: Re: how to calculate several cells in a row On the =a1: f1) there was not an open ( shown shouldn't it be =sum(a: f:)? On 12/27/2014 4:19 PM, Kevin Shaw wrote: 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.
Re: how to calculate several cells in a row
And no space within brackets between the coordinates, as far as I can remember. On 27 Dec 2014, at 23:27, Yolanda ylt...@gmail.com wrote: On the =a1: f1) there was not an open ( shown shouldn't it be =sum(a: f:)? On 12/27/2014 4:19 PM, Kevin Shaw wrote: 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.
Re: how to calculate several cells in a row
I can't speak with any certainty if white space cannot be interspersed on a Mac system, but it makes no difference in Excel on Windows. In short, the expressions: SUM(A1:F1) SUM ( A1 : F1 ) are equivalent and syntactically correct (the second sample has spaces interspersed throughout). Merry Christmas Happy New Year to You and Yours Holland and Bill - Scrooge, witnessing the Cratchet family Christmas celebration, begins an exchange with the Spirit of Christmas Present: - `Spirit,' said Scrooge, with an interest he had never felt before, `tell me if Tiny Tim will live.' `I see a vacant seat,' replied the Ghost, `in the poor chimney-corner, and a crutch without an owner, carefully preserved. If these shadows remain unaltered by the Future, the child will die.' `No, no,' said Scrooge. `Oh, no, kind Spirit. say he will be spared.' `If these shadows remain unaltered by the Future, none other of my race,' returned the Ghost, `will find him here. What then. If he be like to die, he had better do it, and decrease the surplus population.' Scrooge hung his head to hear his own words quoted by the Spirit, and was overcome with penitence and grief. - A Christmas Carol, 1843, Charles Dickens - Original Message - From: Andrew Lamanche ioani...@me.com To: macvisionaries@googlegroups.com Sent: Sunday, December 28, 2014 4:27 AM Subject: Re: how to calculate several cells in a row And no space within brackets between the coordinates, as far as I can remember. On 27 Dec 2014, at 23:27, Yolanda ylt...@gmail.com wrote: On the =a1: f1) there was not an open ( shown shouldn't it be =sum(a: f:)? On 12/27/2014 4:19 PM, Kevin Shaw wrote: 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. --- This email is free from viruses and malware because avast! Antivirus protection is active. http://www.avast.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 http://groups.google.com/group/macvisionaries. For more options, visit https://groups.google.com/d/optout.
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.
Re: how to calculate several cells in a row
On the =a1: f1) there was not an open ( shown shouldn't it be =sum(a: f:)? On 12/27/2014 4:19 PM, Kevin Shaw wrote: 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.