IF you don't have numbers in between the ones you want to sum, just sum
the entire range.

If you do have numbers, you can use something like this:

=SUMPRODUCT(--(MOD(ROW(A1:A100),2)=0),A1:A100)

which sums the even rows. Change the 0 to 1 to sum the odd rows.

Alternatively, select your desired cells and name them by entering a
name (say, "myrange", without quotes) in the Name box at the left of the
formula bar. Then you can use

=SUM(myrange)

to sum all the cells in the named range.



In article ,
Fredneck Angela <Fredneck wrote:

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