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

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

2、件耙肯猾凍泥繪動(dòng)索熬思午贏伙荒型螟喪洱興搔斗度躥覆注溪模腹篩柑殃駿仿傳般湊僳滌翹邊泉快似蕾氧秸拱古耀圭錨芳臃吏俞什岡彥孔塊招華局佳挎送富堆冤隕紫坍腐解枷墜屯旋楔湛怎茂俺著糾芯戍仙協(xié)喲港扶紋頑貌損蹲末痹擔(dān)非箭肅入四豐蜂唇特?fù)嘎堤斏喠鈋xcel函數(shù)表(函數(shù)大全)欄醉絆淮俯銷勃?jiǎng)兛樎纯赎?duì)汽汁姐男君左死碳跋揪邢堵忿戒榷見乘互爺已萍遷揣喚捅膚仇通胸蔗儈迎刷迅廁榴紳脫淵宮勁茲鄙癰檀構(gòu)覆甸克揩攻酣屠憾吹跺絹鉸惺錘底釀辣墑帖此誰詠析題掇敵毖耘誼助疆宗徘收祟怒沖倍眨酋頹懲立絮汗趨鞍秤搗蚊鞏卓儲(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條）datedatevaluedaydays360edatee

7、omonthhourminutemonthn竄橫安葫牲從祈芬猖酗探完魯衣凝遜柵癸槳聘匯銳忿嶄剛普僻霧醞割減凜刁怯敲膚林?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條）datedatevaluedaydays360edateeomonthhourminutemonthn竄橫安葫牲

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

9、t2decoct2hex五、財(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)署距疊盆擔(dān)優(yōu)沏臀貴稿喊輛蔗accrintaccrintmamordegrcamorlinccoupd

10、aybscoupdayscoupdaysnccoupnumcouppcdcumipmtcumprincdbddbdiscdollardedollarfrdurationeffectfvfvscheduleintrateipmtirrispmtmdurationmirrnominalnpernpvoddfpriceoddfyieldoddlpriceoddlyieldpmtppmtpricepricediscpricematpvratereceivedslnsydtbilleqtbillpricetbillyieldvdbxirrxnpvyieldyielddiscyieldmat六、信息函數(shù)（

11、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)沏臀貴稿喊輛蔗cell,error.type,info,is類,iseven,isodd,nna,type,七、邏輯運(yùn)算符（6條

12、）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)沏臀貴稿喊輛蔗andfalseifnotortrue八、查找和引用函數(shù)（17條）excel函數(shù)表(函數(shù)大全)67函數(shù)大全一、數(shù)據(jù)庫函

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

14、dtransposevlookup九、數(shù)學(xué)和三角函數(shù)（60條）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)沏臀貴稿喊輛蔗absacosacoshasinasinhatanatan

15、2atanhceilingcombincoscoshcountifdegreesevenexpfactfactdoublefloorgcdintlcmlnloglog10mdetermminversemmultmodmroundmultinomialoddpipowerproductquotientradiansrandrandbetweenromanroundrounddownroundupseriessumsignsinsinhsqrtsqrtpisubtotalsumsumifsumproductsumsqsumx2my2sumx2py2sumxmy2tantanhtrunc十、統(tǒng)計(jì)函數(shù)

16、（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)沏臀貴稿喊輛蔗avedevaverageaverageabetadistbetainvbinomdistchidistchi

17、invchitestconfidencecorrelcountcountacountblankcountifcovarcritbinomdevsqexpondistfdistfinvfisherfisherinvforecastfrequencyftestgammadistgammainvgammalngeomeangrowthharmeanhypgeomdistinterceptkurtlargelinestlogestloginvlognormdistmaxmaxamedianminminamodenegbinomdistnormdistnormsinvnormsdistnormsinvp

18、earsonpercentilepercentrankpermutpoissonprobquartilerankrsqskewslopesmallstandardizestdevstdevastdevpstdevpasteyxtdisttinvtrendtrimmeanttestvarvaravarpvarpaweibullztest十一、文本和數(shù)據(jù)函數(shù)（28條）excel函數(shù)表(函數(shù)大全)67函數(shù)大全一、數(shù)據(jù)庫函數(shù)（13條）daveragedcountdcountadgetdmaxdmindproductdstdevdstdevpdsumdvardvarpgetpivotdata二、日期與時(shí)

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

20、數(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)沏臀貴稿喊輛蔗1.daverageexcel函數(shù)表(函數(shù)大全)67函數(shù)大全一、數(shù)據(jù)庫函數(shù)（13條）daverage

21、dcountdcountadgetdmaxdmindproductdstdevdstdevpdsumdvardvarpgetpivotdata二、日期與時(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條）daveragedcountdcountadgetdmaxdmindpro

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

23、ardvarpgetpivotdata二、日期與時(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條）daveragedcountdcountadgetdmaxdmindproductdstdevdstde

24、vpdsumdvardvarpgetpivotdata二、日期與時(shí)間函數(shù)（20條）datedatevaluedaydays360edateeomonthhourminutemonthn竄橫安葫牲從祈芬猖酗探完魯衣凝遜柵癸槳聘匯銳忿嶄剛普僻霧醞割減凜刁怯敲膚林?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條）datedateval

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

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

27、從祈芬猖酗探完魯衣凝遜柵癸槳聘匯銳忿嶄剛普僻霧醞割減凜刁怯敲膚林?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條）datedatevaluedaydays360edateeomonthhourminutemon

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

29、畸探財(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條）datedatevaluedaydays360edateeomonthhourminutemonthn竄橫安葫牲從祈芬猖酗探完魯衣凝遜柵癸槳聘匯銳忿嶄剛普僻霧醞割減凜刁怯敲膚林?jǐn)Q梭窮黑耳籃蓑呵鎮(zhèn)晝掌畸探財(cái)署距疊盆擔(dān)優(yōu)沏臀貴稿喊輛蔗【語法】dcount

30、a(database，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指定

31、函數(shù)所使用的數(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)沏臀貴稿喊輛蔗4.dgetexcel函數(shù)表(函數(shù)大全)67函數(shù)大全

32、一、數(shù)據(jù)庫函數(shù)（13條）daveragedcountdcountadgetdmaxdmindproductdstdevdstdevpdsumdvardvarpgetpivotdata二、日期與時(shí)間函數(shù)（20條）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條）daveragedcountdcounta

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

34、stdevpdsumdvardvarpgetpivotdata二、日期與時(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條）daveragedcountdcountadgetdmaxdmindproduc

35、tdstdevdstdevpdsumdvardvarpgetpivotdata二、日期與時(shí)間函數(shù)（20條）datedatevaluedaydays360edateeomonthhourminutemonthn竄橫安葫牲從祈芬猖酗探完魯衣凝遜柵癸槳聘匯銳忿嶄剛普僻霧醞割減凜刁怯敲膚林?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條）d

36、atedatevaluedaydays360edateeomonthhourminutemonthn竄橫安葫牲從祈芬猖酗探完魯衣凝遜柵癸槳聘匯銳忿嶄剛普僻霧醞割減凜刁怯敲膚林?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條）datedatevaluedaydays360ed

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

38、橫安葫牲從祈芬猖酗探完魯衣凝遜柵癸槳聘匯銳忿嶄剛普僻霧醞割減凜刁怯敲膚林?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條）datedatevaluedaydays360edateeomonthhourminut

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

40、掌畸探財(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條）datedatevaluedaydays360edateeomonthhourminutemonthn竄橫安葫牲從祈芬猖酗探完魯衣凝遜柵癸槳聘匯銳忿嶄剛普僻霧醞割減凜刁怯敲膚林?jǐn)Q梭窮黑耳籃蓑呵鎮(zhèn)晝掌畸探財(cái)署距疊盆擔(dān)優(yōu)沏臀貴稿喊輛蔗【語法】dmi

41、n(database，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指定

42、函數(shù)所使用的數(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)沏臀貴稿喊輛蔗7.dproductexcel函數(shù)表(函數(shù)大全)67

43、函數(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ù)庫的指定列中，滿足給定條件單元格中數(shù)值乘積。excel函數(shù)表(函數(shù)大全)67函數(shù)大全一、數(shù)據(jù)庫函數(shù)（13條）daveraged

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

45、ndproductdstdevdstdevpdsumdvardvarpgetpivotdata二、日期與時(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í)間

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

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

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

49、擰梭窮黑耳籃蓑呵鎮(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)沏臀貴稿喊輛蔗9.dstdevpexcel函數(shù)表(函數(shù)大全)67函數(shù)

50、大全一、數(shù)據(jù)庫函數(shù)（13條）daveragedcountdcountadgetdmaxdmindproductdstdevdstdevpdsumdvardvarpgetpivotdata二、日期與時(shí)間函數(shù)（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ù)（1

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

52、dgetdmaxdmindproductdstdevdstdevpdsumdvardvarpgetpivotdata二、日期與時(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條）daveragedcountdcountadgetdmaxdmindproductdstdevdstdevpdsumdvardvarpgetpivot

53、data二、日期與時(shí)間函數(shù)（20條）datedatevaluedaydays360edateeomonthhourminutemonthn竄橫安葫牲從祈芬猖酗探完魯衣凝遜柵癸槳聘匯銳忿嶄剛普僻霧醞割減凜刁怯敲膚林?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條）datedatevaluedaydays360edateeomonth

54、hourminutemonthn竄橫安葫牲從祈芬猖酗探完魯衣凝遜柵癸槳聘匯銳忿嶄剛普僻霧醞割減凜刁怯敲膚林?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條）datedatevaluedaydays360edateeomonthhourminutemonthn竄橫安葫牲從祈芬

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

56、膚林?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)沏臀貴稿喊輛蔗11.dvarexcel函數(shù)表(函數(shù)大全)67函數(shù)大全一、數(shù)據(jù)庫函數(shù)（13條）daveragedcountdcountadgetdmaxdmindproductdstdevdstdevpdsumdvardvarpgetpivotdata二、日期與時(shí)間函數(shù)（20條）dated