摘要:
sumif函数 =SUMIF(E:E,E2,F:F) =SUMIF(F:F,">500") =SUMIF(A:A,F3&"*",B:B) =SUMIF(D:D,H4,F:F) =SUMIF(A:I,L3,$B$1) =SUMIF(A:A,J5&K5,G:G) =SUMIFS(G:G,E:E,J13, 阅读全文
摘要:
countif函数 =COUNTIF(E2:E53,H8) =COUNT(B4:G4) =COUNTIF(B2:G2,">=60") =COUNTIF(A2:A3,A2&"*") 填充的颜色是用了规则(上面有讲述) =IF(COUNTIFS(G:G,A4)=0,"未体检","已体检") 在数据有效性 阅读全文