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" <[email protected]>
To: <[email protected]>
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 <[email protected]> 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 <[email protected]> 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 [email protected].
To post to this group, send email to [email protected].
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 [email protected].
To post to this group, send email to [email protected].
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 [email protected].
To post to this group, send email to [email protected].
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 [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/macvisionaries.
For more options, visit https://groups.google.com/d/optout.
