Re: how to calculate several cells in a row

2014-12-28 Thread BobH.
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

Re: how to calculate several cells in a row

2014-12-28 Thread BobH.
: 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

Re: how to calculate several cells in a row

2014-12-28 Thread BobH.
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

Re: how to calculate several cells in a row

2014-12-28 Thread Andrew Lamanche
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

Re: how to calculate several cells in a row

2014-12-28 Thread Bill Gallik
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

how to calculate several cells in a row

2014-12-27 Thread Scott Berry
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

Re: how to calculate several cells in a row

2014-12-27 Thread Kevin Shaw
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

Re: how to calculate several cells in a row

2014-12-27 Thread Yolanda
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,