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