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?
.