图片没有行标列标,自己参考吧:
=SUMIFS(B3:L3,B1:L1,"计划",B2:L2,"<="&TODAY())-SUMIFS(B3:L3,B1:L1,"达成",B2:L2,"<="&TODAY())
自己手动把两行的答案填入,有助于答题者分析计算规则。“累积票数”是的鬼?