|
- UID
- 222267
- 帖子
- 314
- 主题
- 68
- 注册时间
- 2011-7-2
- 最后登录
- 2016-4-19
|
Right here bro:
=IF(ISERROR(SUM(OFFSET(A$1,(ROW(A1)-1)*10,,10,)))/10,"",SUM(OFFSET(A$1,(ROW(A1)-1)*10,,10,))/10)
If the columns are on a sheet starting at A1, just paste this formula beside the columns and drag it to make it apply to all columns
And boom goes the dynamite |
|
发表于 2011-10-5 09:55
|