
- UID
- 223397
- 帖子
- 276
- 主题
- 21
- 注册时间
- 2011-7-11
- 最后登录
- 2014-8-7
|
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 |
|