百度作业网excel公式求简化!
来源：学生作业帮 编辑：百度作业网作业帮 分类：综合作业 时间：2024/05/13 19:00:10
excel公式求简化!
=SUM(COUNTIF(INDIRECT("C"&ROW()&":"&ADDRESS(ROW(),MATCH(TODAY(),$A$20:$AG$20,0))),{"A","E","F"}))*10
=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
=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