excel公式求简化!=SUM(COUNTIF(INDIRECT("C"&ROW()&":"&ADDRESS(ROW(),MATCH(TODAY(),$A$20:$AG$20,0))),{"A","E","F"}))*10
来源:学生作业帮助网 编辑:作业帮 时间:2024/09/02 18:01:20
excel公式求简化!=SUM(COUNTIF(INDIRECT("C"&ROW()&":"&ADDRESS(ROW(),MATCH(TODAY(),$A$20:$AG$20,0))),{"A","E","F"}))*10
excel公式求简化!
=SUM(COUNTIF(INDIRECT("C"&ROW()&":"&ADDRESS(ROW(),MATCH(TODAY(),$A$20:$AG$20,0))),{"A","E","F"}))*10
excel公式求简化!=SUM(COUNTIF(INDIRECT("C"&ROW()&":"&ADDRESS(ROW(),MATCH(TODAY(),$A$20:$AG$20,0))),{"A","E","F"}))*10
试下这公式看看:
=10*sumproduct(--(offset($c$1,row()-1,match(today(),$a$20:$ag$20,)-2)={"A";"E";"F"}))
或者
=sum(countif(indirect("rc3:rc"&match(today(),$a$20:$ag$20,),),{"A","E","F"}))*10