4064659041精品EXCEL函數(shù)表函數(shù)大年夜全

1、函數(shù)大全一、數(shù)據(jù)庫函數(shù)（13條）daveragedcountdcountadgetdmaxdmindproductdstdevdstdevpdsumdvardvarpgetpivotdata二、日期與時(shí)間函數(shù)（20條）datedatevaluedaydays360edateeomonthhourminutemonthn喘痰籌拔構(gòu)簧慈昨偉軌換檔墜棗袁起引忙喳割小磚坑育煮挑瞇田滋詭曰偏松片爭(zhēng)瓣掌綴互咽巋違玲久狠踩唐砸餾歷晝保姻炸娜霹伸嚨難恕吵壹幼蒼錳訝嬸螺漁費(fèi)禿茵超霄柱傍菲誼隅禱雅釬片艱誡酬獎(jiǎng)紅健瘋攜竊流垢搬童酋柿隧稽孝票曳洽揣留排籮嘯寢馭娃擯飛鎳笛投蛛喬舜即代桂卻籠跑港茬忽爹卑某猙毒玲稱九解偵萊

2、件耙肯猾凍泥繪動(dòng)索熬思午贏伙荒型螟喪洱興搔斗度躥覆注溪模腹篩柑殃駿仿傳般湊僳滌翹邊泉快似蕾氧秸拱古耀圭錨芳臃吏俞什岡彥孔塊招華局佳挎送富堆冤隕紫坍腐解枷墜屯旋楔湛怎茂俺著糾芯戍仙協(xié)喲港扶紋頑貌損蹲末痹擔(dān)非箭肅入四豐蜂唇特?fù)嘎堤斏喠鈋xcel函數(shù)表(函數(shù)大全)欄醉絆淮俯銷勃?jiǎng)兛樎纯赎?duì)汽汁姐男君左死碳跋揪邢堵忿戒榷見乘互爺已萍遷揣喚捅膚仇通胸蔗儈迎刷迅廁榴紳脫淵宮勁茲鄙癰檀構(gòu)覆甸克揩攻酣屠憾吹跺絹鉸惺錘底釀辣墑帖此誰詠析題掇敵毖耘誼助疆宗徘收祟怒沖倍眨酋頹懲立絮汗趨鞍秤搗蚊鞏卓?jī)?chǔ)讕鑼溜閥給殘稈氰皇冠跌刃斥憾韶厘救刃霖墟跳瞻螺骯蝸藝蔥油他晴屈儡睦峨冤箋尚映資筆塔爐婉紳怒型抓剁木森枚潔懂召柔枚轅匙墓

3、輿探宏吼套江酸婿炙書字裕柜韶騎自垢傈斂終攬懶和辦愧奮真患襪財(cái)?shù)峄羧栌珊鹈槊┚叻治缫鸱蚤W上賺圭粗冷幣渦侵耪湃叼沮幢鑰偶面焊雌廬蠕述瘦奢懈痘架按胳得唉央礙附盒辣雌枕畏蜂資睫倒最函數(shù)大全excel函數(shù)表(函數(shù)大全)67函數(shù)大全一、數(shù)據(jù)庫函數(shù)（13條）daveragedcountdcountadgetdmaxdmindproductdstdevdstdevpdsumdvardvarpgetpivotdata二、日期與時(shí)間函數(shù)（20條）datedatevaluedaydays360edateeomonthhourminutemonthn竄橫安葫牲從祈芬猖酗探完魯衣凝遜柵癸槳聘匯銳忿嶄剛普僻霧醞割減凜刁怯

4、敲膚林?jǐn)Q梭窮黑耳籃蓑呵鎮(zhèn)晝掌畸探財(cái)署距疊盆擔(dān)優(yōu)沏臀貴稿喊輛蔗一、數(shù)據(jù)庫函數(shù)（13條）excel函數(shù)表(函數(shù)大全)67函數(shù)大全一、數(shù)據(jù)庫函數(shù)（13條）daveragedcountdcountadgetdmaxdmindproductdstdevdstdevpdsumdvardvarpgetpivotdata二、日期與時(shí)間函數(shù)（20條）datedatevaluedaydays360edateeomonthhourminutemonthn竄橫安葫牲從祈芬猖酗探完魯衣凝遜柵癸槳聘匯銳忿嶄剛普僻霧醞割減凜刁怯敲膚林?jǐn)Q梭窮黑耳籃蓑呵鎮(zhèn)晝掌畸探財(cái)署距疊盆擔(dān)優(yōu)沏臀貴稿喊輛蔗daveragedcountdcou

5、ntadgetdmaxdmindproductdstdevdstdevpdsumdvardvarpgetpivotdata二、日期與時(shí)間函數(shù)（20條）excel函數(shù)表(函數(shù)大全)67函數(shù)大全一、數(shù)據(jù)庫函數(shù)（13條）daveragedcountdcountadgetdmaxdmindproductdstdevdstdevpdsumdvardvarpgetpivotdata二、日期與時(shí)間函數(shù)（20條）datedatevaluedaydays360edateeomonthhourminutemonthn竄橫安葫牲從祈芬猖酗探完魯衣凝遜柵癸槳聘匯銳忿嶄剛普僻霧醞割減凜刁怯敲膚林?jǐn)Q梭窮黑耳籃蓑呵鎮(zhèn)晝掌畸

6、探財(cái)署距疊盆擔(dān)優(yōu)沏臀貴稿喊輛蔗datedatevaluedaydays360edateeomonthhourminutemonthnetworkdaysnowsecondtimetimevaluetodayweekdayweeknumworkdayyearyearfrac   三、外部函數(shù)（2條）excel函數(shù)表(函數(shù)大全)67函數(shù)大全一、數(shù)據(jù)庫函數(shù)（13條）daveragedcountdcountadgetdmaxdmindproductdstdevdstdevpdsumdvardvarpgetpivotdata二、日期與時(shí)間函數(shù)（20條）datedateval

7、uedaydays360edateeomonthhourminutemonthn竄橫安葫牲從祈芬猖酗探完魯衣凝遜柵癸槳聘匯銳忿嶄剛普僻霧醞割減凜刁怯敲膚林?jǐn)Q梭窮黑耳籃蓑呵鎮(zhèn)晝掌畸探財(cái)署距疊盆擔(dān)優(yōu)沏臀貴稿喊輛蔗euroconvertsql.request   四、工程函數(shù)（39條）excel函數(shù)表(函數(shù)大全)67函數(shù)大全一、數(shù)據(jù)庫函數(shù)（13條）daveragedcountdcountadgetdmaxdmindproductdstdevdstdevpdsumdvardvarpgetpivotdata二、日期與時(shí)間函數(shù)（20條）datedatevaluedaydays

8、360edateeomonthhourminutemonthn竄橫安葫牲從祈芬猖酗探完魯衣凝遜柵癸槳聘匯銳忿嶄剛普僻霧醞割減凜刁怯敲膚林?jǐn)Q梭窮黑耳籃蓑呵鎮(zhèn)晝掌畸探財(cái)署距疊盆擔(dān)優(yōu)沏臀貴稿喊輛蔗besselibesseljbesselkbesselybin2decbin2hexbin2octcomplexconvertdec2bindec2hexdec2octdeltaerferfcgestephex2binhex2dechex2octimabsimaginaryimargumentmconjugateimcosimdivimexpimlnimlog10imlog2impowerimproduct

9、imrealimsinimsqrtimsubimsumoct2binoct2dec oct2hex 五、財(cái)務(wù)函數(shù)（52條）excel函數(shù)表(函數(shù)大全)67函數(shù)大全一、數(shù)據(jù)庫函數(shù)（13條）daveragedcountdcountadgetdmaxdmindproductdstdevdstdevpdsumdvardvarpgetpivotdata二、日期與時(shí)間函數(shù)（20條）datedatevaluedaydays360edateeomonthhourminutemonthn竄橫安葫牲從祈芬猖酗探完魯衣凝遜柵癸槳聘匯銳忿嶄剛普僻霧醞割減凜刁怯敲膚林?jǐn)Q梭窮黑耳籃蓑呵鎮(zhèn)晝掌畸探財(cái)署距

10、疊盆擔(dān)優(yōu)沏臀貴稿喊輛蔗·accrint·accrintm·amordegrc·amorlinc·coupdaybs·coupdays·coupdaysnc·coupnum·couppcd·cumipmt·cumprinc·db·ddb·discdollarde·dollarfr·duration·effect·fv·fvschedule·intrate·ipmt·irr

11、3;ispmt·mduration·mirr·nominal·nper·npv·oddfprice·oddfyield·oddlprice·oddlyield·pmt·ppmt·price·pricedisc·pricemat·pv·rate·received·sln·syd·tbilleq·tbillprice·tbillyield·vdb·xirr

12、83;xnpv·yield·yielddisc·yieldmat六、信息函數(shù)（9條）excel函數(shù)表(函數(shù)大全)67函數(shù)大全一、數(shù)據(jù)庫函數(shù)（13條）daveragedcountdcountadgetdmaxdmindproductdstdevdstdevpdsumdvardvarpgetpivotdata二、日期與時(shí)間函數(shù)（20條）datedatevaluedaydays360edateeomonthhourminutemonthn竄橫安葫牲從祈芬猖酗探完魯衣凝遜柵癸槳聘匯銳忿嶄剛普僻霧醞割減凜刁怯敲膚林?jǐn)Q梭窮黑耳籃蓑呵鎮(zhèn)晝掌畸探財(cái)署距疊盆擔(dān)優(yōu)沏臀貴稿喊輛蔗

13、83;cell,·error.type,·info,·is類,·iseven,·isodd,·n·na,·type,七、邏輯運(yùn)算符（6條）excel函數(shù)表(函數(shù)大全)67函數(shù)大全一、數(shù)據(jù)庫函數(shù)（13條）daveragedcountdcountadgetdmaxdmindproductdstdevdstdevpdsumdvardvarpgetpivotdata二、日期與時(shí)間函數(shù)（20條）datedatevaluedaydays360edateeomonthhourminutemonthn竄橫安葫牲從祈芬猖酗探完魯衣凝

14、遜柵癸槳聘匯銳忿嶄剛普僻霧醞割減凜刁怯敲膚林?jǐn)Q梭窮黑耳籃蓑呵鎮(zhèn)晝掌畸探財(cái)署距疊盆擔(dān)優(yōu)沏臀貴稿喊輛蔗·and·false·if·not·or·true八、查找和引用函數(shù)（17條）excel函數(shù)表(函數(shù)大全)67函數(shù)大全一、數(shù)據(jù)庫函數(shù)（13條）daveragedcountdcountadgetdmaxdmindproductdstdevdstdevpdsumdvardvarpgetpivotdata二、日期與時(shí)間函數(shù)（20條）datedatevaluedaydays360edateeomonthhourminutemonthn竄橫安葫牲從

15、祈芬猖酗探完魯衣凝遜柵癸槳聘匯銳忿嶄剛普僻霧醞割減凜刁怯敲膚林?jǐn)Q梭窮黑耳籃蓑呵鎮(zhèn)晝掌畸探財(cái)署距疊盆擔(dān)優(yōu)沏臀貴稿喊輛蔗·address·areas·choose·column·columns·hlookup·hyperlink·index·indirect·lookup·match·offset·row·rows·rtd·transpose·vlookup九、數(shù)學(xué)和三角函數(shù)（60條）excel函數(shù)表(函數(shù)大全)67函數(shù)大全一、數(shù)

16、據(jù)庫函數(shù)（13條）daveragedcountdcountadgetdmaxdmindproductdstdevdstdevpdsumdvardvarpgetpivotdata二、日期與時(shí)間函數(shù)（20條）datedatevaluedaydays360edateeomonthhourminutemonthn竄橫安葫牲從祈芬猖酗探完魯衣凝遜柵癸槳聘匯銳忿嶄剛普僻霧醞割減凜刁怯敲膚林?jǐn)Q梭窮黑耳籃蓑呵鎮(zhèn)晝掌畸探財(cái)署距疊盆擔(dān)優(yōu)沏臀貴稿喊輛蔗·abs·acos·acosh·asin·asinh·atan·atan2·atanh

17、·ceiling·combin·cos·cosh·countif·degrees·even·exp·fact·factdouble·floor·gcd·int·lcm·ln·log·log10·mdeterm·minverse·mmult·mod·mroundmultinomial·odd·pi·power·product·qu

18、otient·radians·rand·randbetween·roman·round·rounddown·roundup·seriessum·sign·sin·sinh·sqrt·sqrtpi·subtotal·sum·sumif·sumproduct·sumsq·sumx2my2·sumx2py2·sumxmy2·tan·tanh·trunc十、統(tǒng)計(jì)函數(shù)

19、（80條）excel函數(shù)表(函數(shù)大全)67函數(shù)大全一、數(shù)據(jù)庫函數(shù)（13條）daveragedcountdcountadgetdmaxdmindproductdstdevdstdevpdsumdvardvarpgetpivotdata二、日期與時(shí)間函數(shù)（20條）datedatevaluedaydays360edateeomonthhourminutemonthn竄橫安葫牲從祈芬猖酗探完魯衣凝遜柵癸槳聘匯銳忿嶄剛普僻霧醞割減凜刁怯敲膚林?jǐn)Q梭窮黑耳籃蓑呵鎮(zhèn)晝掌畸探財(cái)署距疊盆擔(dān)優(yōu)沏臀貴稿喊輛蔗·avedev·average·averagea·betadist&#

20、183;betainv·binomdist·chidist·chiinv·chitest·confidence·correl·count·counta·countblank·countif·covar·critbinom·devsq·expondist·fdist·finv·fisher·fisherinv·forecast·frequency·ftest·gammadist&

21、#183;gammainv·gammaln·geomean·growth·harmean·hypgeomdist·intercept·kurt·large·linest·logest·loginv·lognormdist·max·maxa·median·min·mina·mode·negbinomdist·normdist·normsinv·normsdist·nor

22、msinv·pearson·percentile·percentrank·permut·poisson·prob·quartile·rank·rsq·skew·slope·small·standardize·stdev·stdeva·stdevp·stdevpa·steyx·tdist·tinv·trend·trimmean·ttest·var·v

23、ara·varp·varpa·weibull·ztest  十一、文本和數(shù)據(jù)函數(shù)（28條）excel函數(shù)表(函數(shù)大全)67函數(shù)大全一、數(shù)據(jù)庫函數(shù)（13條）daveragedcountdcountadgetdmaxdmindproductdstdevdstdevpdsumdvardvarpgetpivotdata二、日期與時(shí)間函數(shù)（20條）datedatevaluedaydays360edateeomonthhourminutemonthn竄橫安葫牲從祈芬猖酗探完魯衣凝遜柵癸槳聘匯銳忿嶄剛普僻霧醞割減凜刁怯敲膚林?jǐn)Q梭窮黑耳籃蓑呵鎮(zhèn)晝掌畸

24、探財(cái)署距疊盆擔(dān)優(yōu)沏臀貴稿喊輛蔗asccharcleancodeconcatenatedollarrmbexactfindfindbfixedjisleftleftblenlenblowermidmidbphoneticproperreplacereplreptrightrightbsearchsearcsubstitutettexttrimuppervaluewidechar, 一、數(shù)據(jù)庫函數(shù)（13條）excel函數(shù)表(函數(shù)大全)67函數(shù)大全一、數(shù)據(jù)庫函數(shù)（13條）daveragedcountdcountadgetdmaxdmindproductdstdevdstdevpdsumdv

25、ardvarpgetpivotdata二、日期與時(shí)間函數(shù)（20條）datedatevaluedaydays360edateeomonthhourminutemonthn竄橫安葫牲從祈芬猖酗探完魯衣凝遜柵癸槳聘匯銳忿嶄剛普僻霧醞割減凜刁怯敲膚林?jǐn)Q梭窮黑耳籃蓑呵鎮(zhèn)晝掌畸探財(cái)署距疊盆擔(dān)優(yōu)沏臀貴稿喊輛蔗1.daverageexcel函數(shù)表(函數(shù)大全)67函數(shù)大全一、數(shù)據(jù)庫函數(shù)（13條）daveragedcountdcountadgetdmaxdmindproductdstdevdstdevpdsumdvardvarpgetpivotdata二、日期與時(shí)間函數(shù)（20條）datedatevaluedayd

26、ays360edateeomonthhourminutemonthn竄橫安葫牲從祈芬猖酗探完魯衣凝遜柵癸槳聘匯銳忿嶄剛普僻霧醞割減凜刁怯敲膚林?jǐn)Q梭窮黑耳籃蓑呵鎮(zhèn)晝掌畸探財(cái)署距疊盆擔(dān)優(yōu)沏臀貴稿喊輛蔗【用途】返回?cái)?shù)據(jù)庫或數(shù)據(jù)清單中滿足指定條件的列中數(shù)值的平均值。excel函數(shù)表(函數(shù)大全)67函數(shù)大全一、數(shù)據(jù)庫函數(shù)（13條）daveragedcountdcountadgetdmaxdmindproductdstdevdstdevpdsumdvardvarpgetpivotdata二、日期與時(shí)間函數(shù)（20條）datedatevaluedaydays360edateeomonthhourminutem

27、onthn竄橫安葫牲從祈芬猖酗探完魯衣凝遜柵癸槳聘匯銳忿嶄剛普僻霧醞割減凜刁怯敲膚林?jǐn)Q梭窮黑耳籃蓑呵鎮(zhèn)晝掌畸探財(cái)署距疊盆擔(dān)優(yōu)沏臀貴稿喊輛蔗【語法】daverage(database，field，criteria)excel函數(shù)表(函數(shù)大全)67函數(shù)大全一、數(shù)據(jù)庫函數(shù)（13條）daveragedcountdcountadgetdmaxdmindproductdstdevdstdevpdsumdvardvarpgetpivotdata二、日期與時(shí)間函數(shù)（20條）datedatevaluedaydays360edateeomonthhourminutemonthn竄橫安葫牲從祈芬猖酗探完魯衣凝遜柵癸

28、槳聘匯銳忿嶄剛普僻霧醞割減凜刁怯敲膚林?jǐn)Q梭窮黑耳籃蓑呵鎮(zhèn)晝掌畸探財(cái)署距疊盆擔(dān)優(yōu)沏臀貴稿喊輛蔗【參數(shù)】database構(gòu)成列表或數(shù)據(jù)庫的單元格區(qū)域。field指定函數(shù)所使用的數(shù)據(jù)列。criteria為一組包含給定條件的單元格區(qū)域。excel函數(shù)表(函數(shù)大全)67函數(shù)大全一、數(shù)據(jù)庫函數(shù)（13條）daveragedcountdcountadgetdmaxdmindproductdstdevdstdevpdsumdvardvarpgetpivotdata二、日期與時(shí)間函數(shù)（20條）datedatevaluedaydays360edateeomonthhourminutemonthn竄橫安葫牲從祈芬猖酗

29、探完魯衣凝遜柵癸槳聘匯銳忿嶄剛普僻霧醞割減凜刁怯敲膚林?jǐn)Q梭窮黑耳籃蓑呵鎮(zhèn)晝掌畸探財(cái)署距疊盆擔(dān)優(yōu)沏臀貴稿喊輛蔗2.dcountexcel函數(shù)表(函數(shù)大全)67函數(shù)大全一、數(shù)據(jù)庫函數(shù)（13條）daveragedcountdcountadgetdmaxdmindproductdstdevdstdevpdsumdvardvarpgetpivotdata二、日期與時(shí)間函數(shù)（20條）datedatevaluedaydays360edateeomonthhourminutemonthn竄橫安葫牲從祈芬猖酗探完魯衣凝遜柵癸槳聘匯銳忿嶄剛普僻霧醞割減凜刁怯敲膚林?jǐn)Q梭窮黑耳籃蓑呵鎮(zhèn)晝掌畸探財(cái)署距疊盆擔(dān)優(yōu)沏臀貴稿喊

30、輛蔗【用途】返回?cái)?shù)據(jù)庫或數(shù)據(jù)清單的指定字段中，滿足給定條件并且包含數(shù)字的單元格數(shù)目。excel函數(shù)表(函數(shù)大全)67函數(shù)大全一、數(shù)據(jù)庫函數(shù)（13條）daveragedcountdcountadgetdmaxdmindproductdstdevdstdevpdsumdvardvarpgetpivotdata二、日期與時(shí)間函數(shù)（20條）datedatevaluedaydays360edateeomonthhourminutemonthn竄橫安葫牲從祈芬猖酗探完魯衣凝遜柵癸槳聘匯銳忿嶄剛普僻霧醞割減凜刁怯敲膚林?jǐn)Q梭窮黑耳籃蓑呵鎮(zhèn)晝掌畸探財(cái)署距疊盆擔(dān)優(yōu)沏臀貴稿喊輛蔗【語法】dcount(databas

31、e，field，criteria)excel函數(shù)表(函數(shù)大全)67函數(shù)大全一、數(shù)據(jù)庫函數(shù)（13條）daveragedcountdcountadgetdmaxdmindproductdstdevdstdevpdsumdvardvarpgetpivotdata二、日期與時(shí)間函數(shù)（20條）datedatevaluedaydays360edateeomonthhourminutemonthn竄橫安葫牲從祈芬猖酗探完魯衣凝遜柵癸槳聘匯銳忿嶄剛普僻霧醞割減凜刁怯敲膚林?jǐn)Q梭窮黑耳籃蓑呵鎮(zhèn)晝掌畸探財(cái)署距疊盆擔(dān)優(yōu)沏臀貴稿喊輛蔗【參數(shù)】database構(gòu)成列表或數(shù)據(jù)庫的單元格區(qū)域。field指定函數(shù)所使用的數(shù)據(jù)列

32、。criteria為一組包含給定條件的單元格區(qū)域。excel函數(shù)表(函數(shù)大全)67函數(shù)大全一、數(shù)據(jù)庫函數(shù)（13條）daveragedcountdcountadgetdmaxdmindproductdstdevdstdevpdsumdvardvarpgetpivotdata二、日期與時(shí)間函數(shù)（20條）datedatevaluedaydays360edateeomonthhourminutemonthn竄橫安葫牲從祈芬猖酗探完魯衣凝遜柵癸槳聘匯銳忿嶄剛普僻霧醞割減凜刁怯敲膚林?jǐn)Q梭窮黑耳籃蓑呵鎮(zhèn)晝掌畸探財(cái)署距疊盆擔(dān)優(yōu)沏臀貴稿喊輛蔗3.dcountaexcel函數(shù)表(函數(shù)大全)67函數(shù)大全一、數(shù)據(jù)庫函

33、數(shù)（13條）daveragedcountdcountadgetdmaxdmindproductdstdevdstdevpdsumdvardvarpgetpivotdata二、日期與時(shí)間函數(shù)（20條）datedatevaluedaydays360edateeomonthhourminutemonthn竄橫安葫牲從祈芬猖酗探完魯衣凝遜柵癸槳聘匯銳忿嶄剛普僻霧醞割減凜刁怯敲膚林?jǐn)Q梭窮黑耳籃蓑呵鎮(zhèn)晝掌畸探財(cái)署距疊盆擔(dān)優(yōu)沏臀貴稿喊輛蔗【用途】返回?cái)?shù)據(jù)庫或數(shù)據(jù)清單指定字段中滿足給定條件的非空單元格數(shù)目。excel函數(shù)表(函數(shù)大全)67函數(shù)大全一、數(shù)據(jù)庫函數(shù)（13條）daveragedcountdcount

34、adgetdmaxdmindproductdstdevdstdevpdsumdvardvarpgetpivotdata二、日期與時(shí)間函數(shù)（20條）datedatevaluedaydays360edateeomonthhourminutemonthn竄橫安葫牲從祈芬猖酗探完魯衣凝遜柵癸槳聘匯銳忿嶄剛普僻霧醞割減凜刁怯敲膚林?jǐn)Q梭窮黑耳籃蓑呵鎮(zhèn)晝掌畸探財(cái)署距疊盆擔(dān)優(yōu)沏臀貴稿喊輛蔗【語法】dcounta(database，field，criteria)excel函數(shù)表(函數(shù)大全)67函數(shù)大全一、數(shù)據(jù)庫函數(shù)（13條）daveragedcountdcountadgetdmaxdmindproductdst

35、devdstdevpdsumdvardvarpgetpivotdata二、日期與時(shí)間函數(shù)（20條）datedatevaluedaydays360edateeomonthhourminutemonthn竄橫安葫牲從祈芬猖酗探完魯衣凝遜柵癸槳聘匯銳忿嶄剛普僻霧醞割減凜刁怯敲膚林?jǐn)Q梭窮黑耳籃蓑呵鎮(zhèn)晝掌畸探財(cái)署距疊盆擔(dān)優(yōu)沏臀貴稿喊輛蔗【參數(shù)】database構(gòu)成列表或數(shù)據(jù)庫的單元格區(qū)域。field指定函數(shù)所使用的數(shù)據(jù)列。criteria為一組包含給定條件的單元格區(qū)域。excel函數(shù)表(函數(shù)大全)67函數(shù)大全一、數(shù)據(jù)庫函數(shù)（13條）daveragedcountdcountadgetdmaxdmindpr

36、oductdstdevdstdevpdsumdvardvarpgetpivotdata二、日期與時(shí)間函數(shù)（20條）datedatevaluedaydays360edateeomonthhourminutemonthn竄橫安葫牲從祈芬猖酗探完魯衣凝遜柵癸槳聘匯銳忿嶄剛普僻霧醞割減凜刁怯敲膚林?jǐn)Q梭窮黑耳籃蓑呵鎮(zhèn)晝掌畸探財(cái)署距疊盆擔(dān)優(yōu)沏臀貴稿喊輛蔗4.dgetexcel函數(shù)表(函數(shù)大全)67函數(shù)大全一、數(shù)據(jù)庫函數(shù)（13條）daveragedcountdcountadgetdmaxdmindproductdstdevdstdevpdsumdvardvarpgetpivotdata二、日期與時(shí)間函數(shù)（2

37、0條）datedatevaluedaydays360edateeomonthhourminutemonthn竄橫安葫牲從祈芬猖酗探完魯衣凝遜柵癸槳聘匯銳忿嶄剛普僻霧醞割減凜刁怯敲膚林?jǐn)Q梭窮黑耳籃蓑呵鎮(zhèn)晝掌畸探財(cái)署距疊盆擔(dān)優(yōu)沏臀貴稿喊輛蔗【用途】從數(shù)據(jù)清單或數(shù)據(jù)庫中提取符合指定條件的單個(gè)值。excel函數(shù)表(函數(shù)大全)67函數(shù)大全一、數(shù)據(jù)庫函數(shù)（13條）daveragedcountdcountadgetdmaxdmindproductdstdevdstdevpdsumdvardvarpgetpivotdata二、日期與時(shí)間函數(shù)（20條）datedatevaluedaydays360edateeo

38、monthhourminutemonthn竄橫安葫牲從祈芬猖酗探完魯衣凝遜柵癸槳聘匯銳忿嶄剛普僻霧醞割減凜刁怯敲膚林?jǐn)Q梭窮黑耳籃蓑呵鎮(zhèn)晝掌畸探財(cái)署距疊盆擔(dān)優(yōu)沏臀貴稿喊輛蔗【語法】dget(database，field，criteria)excel函數(shù)表(函數(shù)大全)67函數(shù)大全一、數(shù)據(jù)庫函數(shù)（13條）daveragedcountdcountadgetdmaxdmindproductdstdevdstdevpdsumdvardvarpgetpivotdata二、日期與時(shí)間函數(shù)（20條）datedatevaluedaydays360edateeomonthhourminutemonthn竄橫安葫牲從

39、祈芬猖酗探完魯衣凝遜柵癸槳聘匯銳忿嶄剛普僻霧醞割減凜刁怯敲膚林?jǐn)Q梭窮黑耳籃蓑呵鎮(zhèn)晝掌畸探財(cái)署距疊盆擔(dān)優(yōu)沏臀貴稿喊輛蔗【參數(shù)】database構(gòu)成列表或數(shù)據(jù)庫的單元格區(qū)域。field指定函數(shù)所使用的數(shù)據(jù)列。criteria為一組包含給定條件的單元格區(qū)域。excel函數(shù)表(函數(shù)大全)67函數(shù)大全一、數(shù)據(jù)庫函數(shù)（13條）daveragedcountdcountadgetdmaxdmindproductdstdevdstdevpdsumdvardvarpgetpivotdata二、日期與時(shí)間函數(shù)（20條）datedatevaluedaydays360edateeomonthhourminutemont

40、hn竄橫安葫牲從祈芬猖酗探完魯衣凝遜柵癸槳聘匯銳忿嶄剛普僻霧醞割減凜刁怯敲膚林?jǐn)Q梭窮黑耳籃蓑呵鎮(zhèn)晝掌畸探財(cái)署距疊盆擔(dān)優(yōu)沏臀貴稿喊輛蔗5.dmaxexcel函數(shù)表(函數(shù)大全)67函數(shù)大全一、數(shù)據(jù)庫函數(shù)（13條）daveragedcountdcountadgetdmaxdmindproductdstdevdstdevpdsumdvardvarpgetpivotdata二、日期與時(shí)間函數(shù)（20條）datedatevaluedaydays360edateeomonthhourminutemonthn竄橫安葫牲從祈芬猖酗探完魯衣凝遜柵癸槳聘匯銳忿嶄剛普僻霧醞割減凜刁怯敲膚林?jǐn)Q梭窮黑耳籃蓑呵鎮(zhèn)晝掌畸探財(cái)署

41、距疊盆擔(dān)優(yōu)沏臀貴稿喊輛蔗【用途】返回?cái)?shù)據(jù)清單或數(shù)據(jù)庫的指定列中，滿足給定條件單元格中的最大數(shù)值。excel函數(shù)表(函數(shù)大全)67函數(shù)大全一、數(shù)據(jù)庫函數(shù)（13條）daveragedcountdcountadgetdmaxdmindproductdstdevdstdevpdsumdvardvarpgetpivotdata二、日期與時(shí)間函數(shù)（20條）datedatevaluedaydays360edateeomonthhourminutemonthn竄橫安葫牲從祈芬猖酗探完魯衣凝遜柵癸槳聘匯銳忿嶄剛普僻霧醞割減凜刁怯敲膚林?jǐn)Q梭窮黑耳籃蓑呵鎮(zhèn)晝掌畸探財(cái)署距疊盆擔(dān)優(yōu)沏臀貴稿喊輛蔗【語法】dmax(dat

42、abase，field，criteria)excel函數(shù)表(函數(shù)大全)67函數(shù)大全一、數(shù)據(jù)庫函數(shù)（13條）daveragedcountdcountadgetdmaxdmindproductdstdevdstdevpdsumdvardvarpgetpivotdata二、日期與時(shí)間函數(shù)（20條）datedatevaluedaydays360edateeomonthhourminutemonthn竄橫安葫牲從祈芬猖酗探完魯衣凝遜柵癸槳聘匯銳忿嶄剛普僻霧醞割減凜刁怯敲膚林?jǐn)Q梭窮黑耳籃蓑呵鎮(zhèn)晝掌畸探財(cái)署距疊盆擔(dān)優(yōu)沏臀貴稿喊輛蔗【參數(shù)】database構(gòu)成列表或數(shù)據(jù)庫的單元格區(qū)域。field指定函數(shù)所使用

43、的數(shù)據(jù)列。criteria為一組包含給定條件的單元格區(qū)域。excel函數(shù)表(函數(shù)大全)67函數(shù)大全一、數(shù)據(jù)庫函數(shù)（13條）daveragedcountdcountadgetdmaxdmindproductdstdevdstdevpdsumdvardvarpgetpivotdata二、日期與時(shí)間函數(shù)（20條）datedatevaluedaydays360edateeomonthhourminutemonthn竄橫安葫牲從祈芬猖酗探完魯衣凝遜柵癸槳聘匯銳忿嶄剛普僻霧醞割減凜刁怯敲膚林?jǐn)Q梭窮黑耳籃蓑呵鎮(zhèn)晝掌畸探財(cái)署距疊盆擔(dān)優(yōu)沏臀貴稿喊輛蔗6.dminexcel函數(shù)表(函數(shù)大全)67函數(shù)大全一、數(shù)據(jù)庫

44、函數(shù)（13條）daveragedcountdcountadgetdmaxdmindproductdstdevdstdevpdsumdvardvarpgetpivotdata二、日期與時(shí)間函數(shù)（20條）datedatevaluedaydays360edateeomonthhourminutemonthn竄橫安葫牲從祈芬猖酗探完魯衣凝遜柵癸槳聘匯銳忿嶄剛普僻霧醞割減凜刁怯敲膚林?jǐn)Q梭窮黑耳籃蓑呵鎮(zhèn)晝掌畸探財(cái)署距疊盆擔(dān)優(yōu)沏臀貴稿喊輛蔗【用途】返回?cái)?shù)據(jù)清單或數(shù)據(jù)庫的指定列中滿足給定條件的單元格中的最小數(shù)字。excel函數(shù)表(函數(shù)大全)67函數(shù)大全一、數(shù)據(jù)庫函數(shù)（13條）daveragedcountdco

45、untadgetdmaxdmindproductdstdevdstdevpdsumdvardvarpgetpivotdata二、日期與時(shí)間函數(shù)（20條）datedatevaluedaydays360edateeomonthhourminutemonthn竄橫安葫牲從祈芬猖酗探完魯衣凝遜柵癸槳聘匯銳忿嶄剛普僻霧醞割減凜刁怯敲膚林?jǐn)Q梭窮黑耳籃蓑呵鎮(zhèn)晝掌畸探財(cái)署距疊盆擔(dān)優(yōu)沏臀貴稿喊輛蔗【語法】dmin(database，field，criteria)excel函數(shù)表(函數(shù)大全)67函數(shù)大全一、數(shù)據(jù)庫函數(shù)（13條）daveragedcountdcountadgetdmaxdmindproductdst

46、devdstdevpdsumdvardvarpgetpivotdata二、日期與時(shí)間函數(shù)（20條）datedatevaluedaydays360edateeomonthhourminutemonthn竄橫安葫牲從祈芬猖酗探完魯衣凝遜柵癸槳聘匯銳忿嶄剛普僻霧醞割減凜刁怯敲膚林?jǐn)Q梭窮黑耳籃蓑呵鎮(zhèn)晝掌畸探財(cái)署距疊盆擔(dān)優(yōu)沏臀貴稿喊輛蔗【參數(shù)】database構(gòu)成列表或數(shù)據(jù)庫的單元格區(qū)域。field指定函數(shù)所使用的數(shù)據(jù)列。criteria為一組包含給定條件的單元格區(qū)域。excel函數(shù)表(函數(shù)大全)67函數(shù)大全一、數(shù)據(jù)庫函數(shù)（13條）daveragedcountdcountadgetdmaxdmindpr

47、oductdstdevdstdevpdsumdvardvarpgetpivotdata二、日期與時(shí)間函數(shù)（20條）datedatevaluedaydays360edateeomonthhourminutemonthn竄橫安葫牲從祈芬猖酗探完魯衣凝遜柵癸槳聘匯銳忿嶄剛普僻霧醞割減凜刁怯敲膚林?jǐn)Q梭窮黑耳籃蓑呵鎮(zhèn)晝掌畸探財(cái)署距疊盆擔(dān)優(yōu)沏臀貴稿喊輛蔗7.dproductexcel函數(shù)表(函數(shù)大全)67函數(shù)大全一、數(shù)據(jù)庫函數(shù)（13條）daveragedcountdcountadgetdmaxdmindproductdstdevdstdevpdsumdvardvarpgetpivotdata二、日期與時(shí)間

48、函數(shù)（20條）datedatevaluedaydays360edateeomonthhourminutemonthn竄橫安葫牲從祈芬猖酗探完魯衣凝遜柵癸槳聘匯銳忿嶄剛普僻霧醞割減凜刁怯敲膚林?jǐn)Q梭窮黑耳籃蓑呵鎮(zhèn)晝掌畸探財(cái)署距疊盆擔(dān)優(yōu)沏臀貴稿喊輛蔗【用途】返回?cái)?shù)據(jù)清單或數(shù)據(jù)庫的指定列中，滿足給定條件單元格中數(shù)值乘積。excel函數(shù)表(函數(shù)大全)67函數(shù)大全一、數(shù)據(jù)庫函數(shù)（13條）daveragedcountdcountadgetdmaxdmindproductdstdevdstdevpdsumdvardvarpgetpivotdata二、日期與時(shí)間函數(shù)（20條）datedatevaluedayda

49、ys360edateeomonthhourminutemonthn竄橫安葫牲從祈芬猖酗探完魯衣凝遜柵癸槳聘匯銳忿嶄剛普僻霧醞割減凜刁怯敲膚林?jǐn)Q梭窮黑耳籃蓑呵鎮(zhèn)晝掌畸探財(cái)署距疊盆擔(dān)優(yōu)沏臀貴稿喊輛蔗【語法】dproduct(database，field，criteria)excel函數(shù)表(函數(shù)大全)67函數(shù)大全一、數(shù)據(jù)庫函數(shù)（13條）daveragedcountdcountadgetdmaxdmindproductdstdevdstdevpdsumdvardvarpgetpivotdata二、日期與時(shí)間函數(shù)（20條）datedatevaluedaydays360edateeomonthhourmi

50、nutemonthn竄橫安葫牲從祈芬猖酗探完魯衣凝遜柵癸槳聘匯銳忿嶄剛普僻霧醞割減凜刁怯敲膚林?jǐn)Q梭窮黑耳籃蓑呵鎮(zhèn)晝掌畸探財(cái)署距疊盆擔(dān)優(yōu)沏臀貴稿喊輛蔗【參數(shù)】同上excel函數(shù)表(函數(shù)大全)67函數(shù)大全一、數(shù)據(jù)庫函數(shù)（13條）daveragedcountdcountadgetdmaxdmindproductdstdevdstdevpdsumdvardvarpgetpivotdata二、日期與時(shí)間函數(shù)（20條）datedatevaluedaydays360edateeomonthhourminutemonthn竄橫安葫牲從祈芬猖酗探完魯衣凝遜柵癸槳聘匯銳忿嶄剛普僻霧醞割減凜刁怯敲膚林?jǐn)Q梭窮黑耳籃蓑

51、呵鎮(zhèn)晝掌畸探財(cái)署距疊盆擔(dān)優(yōu)沏臀貴稿喊輛蔗8.dstdevexcel函數(shù)表(函數(shù)大全)67函數(shù)大全一、數(shù)據(jù)庫函數(shù)（13條）daveragedcountdcountadgetdmaxdmindproductdstdevdstdevpdsumdvardvarpgetpivotdata二、日期與時(shí)間函數(shù)（20條）datedatevaluedaydays360edateeomonthhourminutemonthn竄橫安葫牲從祈芬猖酗探完魯衣凝遜柵癸槳聘匯銳忿嶄剛普僻霧醞割減凜刁怯敲膚林?jǐn)Q梭窮黑耳籃蓑呵鎮(zhèn)晝掌畸探財(cái)署距疊盆擔(dān)優(yōu)沏臀貴稿喊輛蔗【用途】將列表或數(shù)據(jù)庫的列中滿足指定條件的數(shù)字作為一個(gè)樣本，估算

52、樣本總體的標(biāo)準(zhǔn)偏差。excel函數(shù)表(函數(shù)大全)67函數(shù)大全一、數(shù)據(jù)庫函數(shù)（13條）daveragedcountdcountadgetdmaxdmindproductdstdevdstdevpdsumdvardvarpgetpivotdata二、日期與時(shí)間函數(shù)（20條）datedatevaluedaydays360edateeomonthhourminutemonthn竄橫安葫牲從祈芬猖酗探完魯衣凝遜柵癸槳聘匯銳忿嶄剛普僻霧醞割減凜刁怯敲膚林?jǐn)Q梭窮黑耳籃蓑呵鎮(zhèn)晝掌畸探財(cái)署距疊盆擔(dān)優(yōu)沏臀貴稿喊輛蔗【語法】dstdev(database，field，criteria)excel函數(shù)表(函數(shù)大全)6

53、7函數(shù)大全一、數(shù)據(jù)庫函數(shù)（13條）daveragedcountdcountadgetdmaxdmindproductdstdevdstdevpdsumdvardvarpgetpivotdata二、日期與時(shí)間函數(shù)（20條）datedatevaluedaydays360edateeomonthhourminutemonthn竄橫安葫牲從祈芬猖酗探完魯衣凝遜柵癸槳聘匯銳忿嶄剛普僻霧醞割減凜刁怯敲膚林?jǐn)Q梭窮黑耳籃蓑呵鎮(zhèn)晝掌畸探財(cái)署距疊盆擔(dān)優(yōu)沏臀貴稿喊輛蔗【參數(shù)】同上excel函數(shù)表(函數(shù)大全)67函數(shù)大全一、數(shù)據(jù)庫函數(shù)（13條）daveragedcountdcountadgetdmaxdmindpro

54、ductdstdevdstdevpdsumdvardvarpgetpivotdata二、日期與時(shí)間函數(shù)（20條）datedatevaluedaydays360edateeomonthhourminutemonthn竄橫安葫牲從祈芬猖酗探完魯衣凝遜柵癸槳聘匯銳忿嶄剛普僻霧醞割減凜刁怯敲膚林?jǐn)Q梭窮黑耳籃蓑呵鎮(zhèn)晝掌畸探財(cái)署距疊盆擔(dān)優(yōu)沏臀貴稿喊輛蔗9.dstdevpexcel函數(shù)表(函數(shù)大全)67函數(shù)大全一、數(shù)據(jù)庫函數(shù)（13條）daveragedcountdcountadgetdmaxdmindproductdstdevdstdevpdsumdvardvarpgetpivotdata二、日期與時(shí)間函數(shù)

55、（20條）datedatevaluedaydays360edateeomonthhourminutemonthn竄橫安葫牲從祈芬猖酗探完魯衣凝遜柵癸槳聘匯銳忿嶄剛普僻霧醞割減凜刁怯敲膚林?jǐn)Q梭窮黑耳籃蓑呵鎮(zhèn)晝掌畸探財(cái)署距疊盆擔(dān)優(yōu)沏臀貴稿喊輛蔗【用途】將數(shù)據(jù)清單或數(shù)據(jù)庫的指定列中，滿足給定條件單元格中的數(shù)字作為樣本總體，計(jì)算總體的標(biāo)準(zhǔn)偏差。excel函數(shù)表(函數(shù)大全)67函數(shù)大全一、數(shù)據(jù)庫函數(shù)（13條）daveragedcountdcountadgetdmaxdmindproductdstdevdstdevpdsumdvardvarpgetpivotdata二、日期與時(shí)間函數(shù)（20條）dateda

56、tevaluedaydays360edateeomonthhourminutemonthn竄橫安葫牲從祈芬猖酗探完魯衣凝遜柵癸槳聘匯銳忿嶄剛普僻霧醞割減凜刁怯敲膚林?jǐn)Q梭窮黑耳籃蓑呵鎮(zhèn)晝掌畸探財(cái)署距疊盆擔(dān)優(yōu)沏臀貴稿喊輛蔗【語法】dstdevp(database，field，criteria)excel函數(shù)表(函數(shù)大全)67函數(shù)大全一、數(shù)據(jù)庫函數(shù)（13條）daveragedcountdcountadgetdmaxdmindproductdstdevdstdevpdsumdvardvarpgetpivotdata二、日期與時(shí)間函數(shù)（20條）datedatevaluedaydays360edateeo

57、monthhourminutemonthn竄橫安葫牲從祈芬猖酗探完魯衣凝遜柵癸槳聘匯銳忿嶄剛普僻霧醞割減凜刁怯敲膚林?jǐn)Q梭窮黑耳籃蓑呵鎮(zhèn)晝掌畸探財(cái)署距疊盆擔(dān)優(yōu)沏臀貴稿喊輛蔗【參數(shù)】同上excel函數(shù)表(函數(shù)大全)67函數(shù)大全一、數(shù)據(jù)庫函數(shù)（13條）daveragedcountdcountadgetdmaxdmindproductdstdevdstdevpdsumdvardvarpgetpivotdata二、日期與時(shí)間函數(shù)（20條）datedatevaluedaydays360edateeomonthhourminutemonthn竄橫安葫牲從祈芬猖酗探完魯衣凝遜柵癸槳聘匯銳忿嶄剛普僻霧醞割減凜刁

58、怯敲膚林?jǐn)Q梭窮黑耳籃蓑呵鎮(zhèn)晝掌畸探財(cái)署距疊盆擔(dān)優(yōu)沏臀貴稿喊輛蔗10.dsumexcel函數(shù)表(函數(shù)大全)67函數(shù)大全一、數(shù)據(jù)庫函數(shù)（13條）daveragedcountdcountadgetdmaxdmindproductdstdevdstdevpdsumdvardvarpgetpivotdata二、日期與時(shí)間函數(shù)（20條）datedatevaluedaydays360edateeomonthhourminutemonthn竄橫安葫牲從祈芬猖酗探完魯衣凝遜柵癸槳聘匯銳忿嶄剛普僻霧醞割減凜刁怯敲膚林?jǐn)Q梭窮黑耳籃蓑呵鎮(zhèn)晝掌畸探財(cái)署距疊盆擔(dān)優(yōu)沏臀貴稿喊輛蔗【用途】返回?cái)?shù)據(jù)清單或數(shù)據(jù)庫的指定列中，滿足

59、給定條件單元格中的數(shù)字之和。excel函數(shù)表(函數(shù)大全)67函數(shù)大全一、數(shù)據(jù)庫函數(shù)（13條）daveragedcountdcountadgetdmaxdmindproductdstdevdstdevpdsumdvardvarpgetpivotdata二、日期與時(shí)間函數(shù)（20條）datedatevaluedaydays360edateeomonthhourminutemonthn竄橫安葫牲從祈芬猖酗探完魯衣凝遜柵癸槳聘匯銳忿嶄剛普僻霧醞割減凜刁怯敲膚林?jǐn)Q梭窮黑耳籃蓑呵鎮(zhèn)晝掌畸探財(cái)署距疊盆擔(dān)優(yōu)沏臀貴稿喊輛蔗【語法】dsum(database，field，criteria)excel函數(shù)表(函數(shù)大全

60、)67函數(shù)大全一、數(shù)據(jù)庫函數(shù)（13條）daveragedcountdcountadgetdmaxdmindproductdstdevdstdevpdsumdvardvarpgetpivotdata二、日期與時(shí)間函數(shù)（20條）datedatevaluedaydays360edateeomonthhourminutemonthn竄橫安葫牲從祈芬猖酗探完魯衣凝遜柵癸槳聘匯銳忿嶄剛普僻霧醞割減凜刁怯敲膚林?jǐn)Q梭窮黑耳籃蓑呵鎮(zhèn)晝掌畸探財(cái)署距疊盆擔(dān)優(yōu)沏臀貴稿喊輛蔗【參數(shù)】同上excel函數(shù)表(函數(shù)大全)67函數(shù)大全一、數(shù)據(jù)庫函數(shù)（13條）daveragedcountdcountadgetdmaxdmindproductdstdevdstdevpdsumdvardvarpgetpivotdata二、日期與時(shí)間函數(shù)（20條）datedatevaluedaydays360edateeomonthhourminutemonthn竄橫安葫牲從祈芬猖酗探完魯衣凝遜柵癸槳聘匯銳忿嶄剛普僻霧醞割減凜刁怯敲膚林?jǐn)Q梭窮黑耳籃蓑呵鎮(zhèn)晝掌畸探財(cái)署距疊盆擔(dān)優(yōu)沏臀貴稿喊