EXCEL中如何查找引用符合条件的数据后返回数值并求和答:在SHEET2的B2:D2分别输入或复制粘贴下列公式 =COUNTIFS(A:A,G2,B:B,">="&TODAY()-DAY(TODAY())+1,B:B,"<="&EOMONTH(TODAY(),0))=SUMIFS(D:D,B:B,">="&TODAY()-DAY(TODAY())+1,B:B,"<="&EOMONTH(TODAY(),0))=SUMIFS(F:F,E:E,">="&TODAY()-DAY(TODAY())+1,E:...