作业帮EXCEL这个公式是什么意思SUM(IF(MOD(COLUMN(G:BW)-4,3)=0,G3:BW3,0))SUM(IF(MOD(COLUMN(G:BW)-4,3)=1,G3:BW3,0))尤其是-4,
来源：学生作业帮助网 编辑：作业帮 时间：2024/05/06 05:04:11
EXCEL这个公式是什么意思SUM(IF(MOD(COLUMN(G:BW)-4,3)=0,G3:BW3,0))SUM(IF(MOD(COLUMN(G:BW)-4,3)=1,G3:BW3,0))尤其是-4,
EXCEL这个公式是什么意思
SUM(IF(MOD(COLUMN(G:BW)-4,3)=0,G3:BW3,0))
SUM(IF(MOD(COLUMN(G:BW)-4,3)=1,G3:BW3,0))
尤其是-4,
EXCEL这个公式是什么意思SUM(IF(MOD(COLUMN(G:BW)-4,3)=0,G3:BW3,0))SUM(IF(MOD(COLUMN(G:BW)-4,3)=1,G3:BW3,0))尤其是-4,
COLUMN(G:BW)是列号,返回一个7-75的数组
{7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75}
COLUMN(G:BW)-4 把这个数组-4,那么数组变成了3-71的数组
{3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71}
MOD(COLUMN(G:BW)-4,3) 对数组取除以3的余数 3除以3余数0 4除以3余数1
上面的数组就变成了：
{0,1,2,0,1,2,0,1,2,0,1,2,0,1,2,0,1,2,0,1,2,0,1,2,0,1,2,0,1,2,0,1,2,0,1,2,0,1,2,0,1,2,0,1,2,0,1,2,0,1,2,0,1,2,0,1,2,0,1,2,0,1,2,0,1,2,0,1,2}
所以上面-4 的目的就是让第一个数变成3那么余数就是0
MOD(COLUMN(G:BW)-4,3)=0 判断是否=0
IF(MOD(COLUMN(G:BW)-4,3)=0,G3:BW3,0)如果列标-4除以3的余数等于0就返回本身,否则返回0
最后求和
总的来说就是对第1,4,7.这样间隔3个数求和
下面那个公式综上分析就是对2,5,8.也是间隔3个数求和