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?

Did you try that? I get a #VALUE! error using the + operator.

Using the union operator works though:

=SUM(Data1,Data2,Data3)

In article ,
"Bernard Liengme" wrote:

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

Opps, typo for comma =SUM(data1,data2...)

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"JE McGimpsey" wrote in message
...
Did you try that? I get a #VALUE! error using the + operator.

Using the union operator works though:

=SUM(Data1,Data2,Data3)

In article ,
"Bernard Liengme" wrote:

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