=SUMPRODUCT(LOOKUP(B2:I2,{0,60,65,70,75,80,85,90},{"",1,1.5,
来源:学生作业帮 编辑:搜搜做题作业网作业帮 分类:数学作业 时间:2024/04/30 00:02:50
=SUMPRODUCT(LOOKUP(B2:I2,{0,60,65,70,75,80,85,90},{"",1,1.5,2,2.5,3,3.5,4}))*5这个函数是什么意思?
SUMPRODUCT是求数组乘积的和,在这里相当于SUM的数组用法,即求一个一维数组的和.
数组是由LOOKUP(B2:I2,{0,60,65,70,75,80,85,90},{"",1,1.5,2,2.5,3,3.5,4})生成的,这部分是根据B2:I2数值,按设定条件返回对应值.
*5将求和结果乘以5.
数组是由LOOKUP(B2:I2,{0,60,65,70,75,80,85,90},{"",1,1.5,2,2.5,3,3.5,4})生成的,这部分是根据B2:I2数值,按设定条件返回对应值.
*5将求和结果乘以5.
=SUMPRODUCT(LOOKUP(B2:I2,{0,60,65,70,75,80,85,90},{"",1,1.5,
=SUMPRODUCT(D6:AH6,LOOKUP(D6:AH6,{0,600,800},{0.048,0.05,0.0
D2中输入 =IF(COUNTIF($B$2:B2,B2)=1,SUMPRODUCT((B2:B999=B2)*C2:C
=sumproduct((b2:b10>b2)/countif(b2:b10,b2:b10))+1这个公式什么意思,看不
LOOKUP函数=LOOKUP(1,0/(C22:AAA22>0),C22:AAA22)
lookup函数=LOOKUP(1,0/($A$1:A6=$A7),$B$1:$B6)得到的是=LOOKUP(1,0/(
在EXCEL中B2=SUMPRODUCT((C4:C39>=75)*C4:C39)的算法意义是什么?
在excel中SUMPRODUCT((COUNTIF($G2:$L2,$B2:$D2)>0)*1)
LOOKUP(D13,{0,60,70,80,100},{"不及格","及格","良好","优秀"})公式中{}的含义?
EXCEL公式 =LOOKUP(2,0/(1:1""),1:
LOOKUP函数求助=LOOKUP(A2,{0,1,2,3,4,5;"0%","2%","4%","6%","8%","
非空个数的问题 求男性及格人数:=SUMPRODUCT((C2:C13>=60)*1,(B2:B13="男")*1)