BUT ... Have you tried *simply* enclosing the whole shebang in *one set* of
double quotes ?

This does work:
=SUM((A1,A3,A5,...,A200))
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Jason Morin" wrote in message
...
One way is to put a subset of the cell references in
parentheses. For example:

=SUM
((A1,A3,A5,A7,A9,A11,A13,A15,A17,A19,A21,A23,A25,A 27,A29,A
31,A33,A35,A37,A39,A41,A43,A45,A47,A49,A51,A53,A55 ,A57),A5
9,A61,A63,A65,A67,A69,A71,A73,A75,A77,A79,A81,A83, A85,A87,
A89)

Notice how the first 29 cell references (A1-A57) are in
parentheses.

HTH
Jason
Atlanta, GA

-----Original Message-----
I am working on Excel 2003 and trying to add a long
column of numbers. Excel
will not allow me to enter more than 30 cells to be
added. They are not
continuous (cells in a single column, but every other
row).

Can anyone help?
.

Just tried it with Average(), and that works also!

Wonder how many others will accept the double quotes?
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Ragdyer" wrote in message
...
BUT ... Have you tried *simply* enclosing the whole shebang in *one set*
of
double quotes ?

This does work:
=SUM((A1,A3,A5,...,A200))
--
Regards,

RD

--------------------------------------------------------------------------
-
Please keep all correspondence within the NewsGroup, so all may benefit !
--------------------------------------------------------------------------
-
"Jason Morin" wrote in message
...
One way is to put a subset of the cell references in
parentheses. For example:

=SUM
((A1,A3,A5,A7,A9,A11,A13,A15,A17,A19,A21,A23,A25,A 27,A29,A
31,A33,A35,A37,A39,A41,A43,A45,A47,A49,A51,A53,A55 ,A57),A5
9,A61,A63,A65,A67,A69,A71,A73,A75,A77,A79,A81,A83, A85,A87,
A89)

Notice how the first 29 cell references (A1-A57) are in
parentheses.

HTH
Jason
Atlanta, GA

-----Original Message-----
I am working on Excel 2003 and trying to add a long
column of numbers. Excel
will not allow me to enter more than 30 cells to be
added. They are not
continuous (cells in a single column, but every other
row).

Can anyone help?
.

RD,

Are you getting your quotes confused with your parentheses? Maybe time to
fix another drink <g

Bob


"Ragdyer" wrote in message
...
BUT ... Have you tried *simply* enclosing the whole shebang in *one set*
of
double quotes ?

This does work:
=SUM((A1,A3,A5,...,A200))
--
Regards,

RD

--------------------------------------------------------------------------
-
Please keep all correspondence within the NewsGroup, so all may benefit !
--------------------------------------------------------------------------
-
"Jason Morin" wrote in message
...
One way is to put a subset of the cell references in
parentheses. For example:

=SUM
((A1,A3,A5,A7,A9,A11,A13,A15,A17,A19,A21,A23,A25,A 27,A29,A
31,A33,A35,A37,A39,A41,A43,A45,A47,A49,A51,A53,A55 ,A57),A5
9,A61,A63,A65,A67,A69,A71,A73,A75,A77,A79,A81,A83, A85,A87,
A89)

Notice how the first 29 cell references (A1-A57) are in
parentheses.

HTH
Jason
Atlanta, GA

-----Original Message-----
I am working on Excel 2003 and trying to add a long
column of numbers. Excel
will not allow me to enter more than 30 cells to be
added. They are not
continuous (cells in a single column, but every other
row).

Can anyone help?
.

Yes, I DID mean Parenthesis !

And you're right, since it's 3 minutes after 12, time to start on today's
ration of Grog.<g
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Bob Phillips" wrote in message
...
RD,

Are you getting your quotes confused with your parentheses? Maybe time to
fix another drink <g

Bob


"Ragdyer" wrote in message
...
BUT ... Have you tried *simply* enclosing the whole shebang in *one set*
of
double quotes ?

This does work:
=SUM((A1,A3,A5,...,A200))
--
Regards,

RD


--------------------------------------------------------------------------
-
Please keep all correspondence within the NewsGroup, so all may benefit
!

--------------------------------------------------------------------------
-
"Jason Morin" wrote in message
...
One way is to put a subset of the cell references in
parentheses. For example:

=SUM
((A1,A3,A5,A7,A9,A11,A13,A15,A17,A19,A21,A23,A25,A 27,A29,A
31,A33,A35,A37,A39,A41,A43,A45,A47,A49,A51,A53,A55 ,A57),A5
9,A61,A63,A65,A67,A69,A71,A73,A75,A77,A79,A81,A83, A85,A87,
A89)

Notice how the first 29 cell references (A1-A57) are in
parentheses.

HTH
Jason
Atlanta, GA

-----Original Message-----
I am working on Excel 2003 and trying to add a long
column of numbers. Excel
will not allow me to enter more than 30 cells to be
added. They are not
continuous (cells in a single column, but every other
row).

Can anyone help?
.