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" <bob.phillips@notheretiscali.co.uk> wrote in message
news:eH6CLZ4FFHA.3972@TK2MSFTNGP15.phx.gbl...
> RD,
>
> Are you getting your quotes confused with your parentheses? Maybe time to
> fix another drink <g>
>
> Bob
>
>
> "Ragdyer" <RagDyer@cutoutmsn.com> wrote in message
> news:e%23wOK93FFHA.3648@TK2MSFTNGP09.phx.gbl...
> > 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" <jasonjmorin@OPPOSITEOFCOLDmail.com> wrote in message
> > news:055401c5175f$4019c5d0$a501280a@phx.gbl...
> > > 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,A27,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?
> > > >.
> > > >
> >
>
>