EXCEL統(tǒng)計(jì)函數(shù)函數(shù)N2=counta(b:b)-1N3=countif(j:j,">=60")-1N4=sum(j:j)/N2{0}2,數(shù)據(jù)庫統(tǒng)計(jì)函數(shù)=COUNTIF(A1:A4,"<60")A1:A4是需要統(tǒng)計(jì)的區(qū)域,"<60"是條件請參考一下sql語句:selectcount(*)from學(xué)生成績表whereA14<60;{1}3,數(shù)據(jù)庫統(tǒng)計(jì)函數(shù)EXCEL中的數(shù)據(jù)庫函數(shù)和相應(yīng)的統(tǒng)計(jì)函數(shù)應(yīng)用類似。比如統(tǒng)計(jì)不及格人數(shù),...
更新時(shí)間:2023-02-27標(biāo)簽: 統(tǒng)計(jì)函數(shù)統(tǒng)計(jì)統(tǒng)計(jì)函數(shù)函數(shù) 全文閱讀