excel公式求简化!=SUM(COUNTIF(INDIRECT("C"&ROW()&":"&ADDRESS(ROW(),MATCH(TODAY(),$A$20:$AG$20,0))),{"A","E","F"}))*10

来源：学生作业学帮网编辑：学帮网时间：2024/05/17 02:56:07

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