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

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

"JE McGimpsey" <jemcgimpsey@mvps.org> wrote in message
news:jemcgimpsey-E0BE0F.08195620022005@msnews.microsoft.com...
> Did you try that? I get a #VALUE! error using the + operator.
>
> Using the union operator works though:
>
> =SUM(Data1,Data2,Data3)
>
> In article <uMVav61FFHA.3244@TK2MSFTNGP15.phx.gbl>,
> "Bernard Liengme" <bliengme@stfx.TRUENORTH.ca> 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....)