| T O P I C R E V I E W |
| mej |
Posted - 02/06/2004 : 06:13:51 AM Hello everybody I have a worksheet with 30 columns and i want to sum the 30 columns (col1+col2+col3+...) and take the mean column. I use the scripts data2_b=sum(data1,a1,a30); or data2_b=sum.mean(data1,a1,a30); ai is the name of the column i But it does not work Thanks |
| 2 L A T E S T R E P L I E S (Newest First) |
| mej |
Posted - 02/06/2004 : 09:48:09 AM It is OK
Thank you Mike |
| Mike Buess |
Posted - 02/06/2004 : 08:04:52 AM The sum function takes column numbers as arguments. Column names do not work.
data2_B=sum(data1,1,30);
Mike Buess Origin WebRing Member |
|
|