Note: You must be registered in order to post a reply. To register, click here. Registration is FREE!
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.