You could name, say, the first 10 as Data1, the next 10 as Data2, etc
Method is: Insert|Name-Define; Data1 refers to A1,A3,A5,A7
The use =sum(Data1+Data2+Data3....)
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Fredneck Angela" <Fredneck wrote in
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?