View Single Post
  #7   Report Post  
Fredneck Angela
 
Posts: n/a
Default

Thanks - this led me to the easiest answer, which was to add together two
sets of SUM(), each with fewer than 30 values inside the parenthesis.

"Jason Morin" wrote:

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