EXCELL公式中=SUMPRODUCT(C4:AJ4*(MOD(C4:AJ4,3)=1)) 最后两个数字1 3

EXCELL公式中=SUMPRODUCT(C4:AJ4*(MOD(C4:AJ4,3)=1)) 最后两个数字1 3 =SUMPRODUCT((C4:AH4)*(MOD(COLUMN(C4:AH4),2)))这个公式为隔行相加,那隔列相加 在EXCEL中B2=SUMPRODUCT((C4:C39>=75)*C4:C39)的算法意义是什么? =SUMPRODUCT(--(0&LEFT(A4:C4,2*LEN(A4:C4)-LENB(A4:C4))))求解释 公式：=WORKDAY(B4,IF(WEEKDAY(B4,2)>=6,C4,C4-1))是个么意思, SUMPRODUCT((MOD(ROW(A1：A100),3)=1)*A1:A100)这个函数公式怎么解释? 关于excel函数公式问题请指点SUMPRODUCT((Sheet2!C4:C18="Sheet1!B1")*(Shee 求Excel公式讲解? =INT(ROUNDUP(($B4-SUM($C$3:C$3*$C4:C4)),4)/D$3) =IF(COUNTIF($C$4:C4,C4)=1,SUMIF($C$4:$C$300,C4,$F$4:$F$300), SUMPRODUCT((MOD('3'!$E$5:$E$100,1)>=1/3)*(MOD('3'!$E$5:$E$10 =SUMPRODUCT((MOD(COLUMN(K4:AB4),3)=2)*K4:AB4)这个公式的大概意思 =SUMPRODUCT((A1:A100)*(MOD(ROW(A1:A100),3)=1)) 求详解