Umsebenzi we-DCOUNT ungomnye wemisebenzi yedatha ye-Excel. Leli qela lemisebenzi lenzelwe ukwenza kube lula ukufingqa ulwazi ukusuka kwiibhuli ezikulu zeedatha. Benza oku ngokubuyisela ulwazi oluthile olusekelwe kwelinye iqela okanye ngaphezulu ekhethwe ngumsebenzisi. Umsebenzi we-DCOUNT ungasetyenziselwa ukugqibelela ixabiso kwikholomu yedata ehambelana neendlela zokubeka.
01 ngo 08
DCOUNT i-Syntax neeArguments
Umsebenzi we-DCOUNT ngu:
= DCOUNT (idatha, inkalo, imigaqo)
Yonke imisebenzi yeenkcukacha zedatha inezizathu ezifanayo ezintathu:
- I-Database : (efunekayo) Icacisa uluhlu lweenkcazo zeeseli eziqulethe database. Amagama endle kufuneka afakwe kwibala.
- Intsimi : (efunekayo) Ubonisa ukuba yeyiphi ikoruba okanye intsimi ekufuneka isetyenziswe ngumsebenzi kubalo. Faka ingxabano mhlawumbi ngokuthayipha igama lefowuni kwiingcaphuno-ezifana "Radius" - okanye faka inombolo yekholomu - efana ne-3.
- Iimpawu : (ezifunekayo) Ukuluhlu uluhlu lweeseli eziqulethe iimeko ezichazwe ngumsebenzisi. Uluhlu kufuneka lubandakanye ubuncinane igama elinye lentsimi ukusuka kwisiseko sedatha kwaye ubuncinane enye enye yeselferensi yesalathisi ebonisa imeko ukuba ihlolwe ngumsebenzi.
02 ngo 08
Umzekelo Ukusebenzisa i-DCX ye-DCOUNT Umsebenzi - Ukulingana neCandelo elilodwa
Cofa kumfanekiso ongentla ngenjongo yokujonga lo mzekelo.
Lo mzekelo uya kusebenzisa i- DCOUNT ukufumana inani elipheleleyo labafundi ababhalise kunyaka wokuqala wekholeji yabo.
03 we-08
Ukufaka i-Tutorial Data
Qaphela: Uqeqesho alubandakanyi amanyathelo okufomatha. Ulwazi malunga neendlela zokwenza ifomathi yomsebenzi lufumaneka kwi- Basic Excel Formatting Tutorial .
- Faka itafile yedata njengoko kuboniswe kumfanekiso ongentla kwiiseli D1 ukuya kwiF15
- Shiya iseli F5 ingenanto-yilapho i-formula ye-DCOUNT izakuba khona
- Amagama endle kwiiseli ze-D2 ukuya ku-F2 ziya kusetyenziswa njengenxalenye yempikiswano yeCriteria
04 we-08
Ukukhetha iCriteria
Ukufumana i-DCOUNT ukuba ibhekisise kuphela idatha yabantwana bokuqala bonyaka sifaka inombolo 1 phantsi kwegama lenkalo yonyaka kumqolo 3.
- Kwiseli, uF3 uthayiphe imilinganiselo 1
- Kwifowuni ye-E5 thayipha iNqaku elipheleleyo: ukubonisa ulwazi esiya kufumana nge-DCOUNT
05 ka 08
Ukubiza igama
Ukusebenzisa uluhlu olukhankanyiweyo olubanzi lweedatha ezifana nedatha ayikwazi ukwenza kube lula ukufaka le ngxabano kumsebenzi, kodwa kunokuthintela iimpazamo ezibangelwa ngokukhetha uluhlu olungalunganga.
Amanqanaba aqingqiweyo ayanceda kakhulu xa usebenzisa uluhlu olufanayo lweeseli rhoqo kwizibalo okanye xa udala amashadi okanye iirafu.
- Khanyisa iiseli ze-D6 ukuya kwi-F15 kwiphepha lokusebenzela ukuze ukhethe uluhlu
- Cofa kwibhokisi yegama ngaphaya kwekholomu A kwiphepha lokusebenzela
- Uhlobo lokubhalisa kwibhokisi legama ukudala uluhlu olukhankanyiweyo
- Cinezela ukhiye wokungena kwikhibhodi ukugqiba ukungena
06 we-08
Ukuvula ibhokisi yeDVD yeDialog
Ibhokisi yencoko yencoko yomsebenzi inikeza indlela elula yokufaka idatha kwiingxoxo zomsebenzi ngamnye.
Ukuvula ibhokisi yencoko kwibhokisi yedatha yemisebenzi yenziwa ngokuchofoza kwinkinobho yomsebenzi wizard (fx) ekhoyo ecaleni kweruba yefomula ngaphezulu kwephepha lokusebenzela - bona umfanekiso ophezulu.
- Cofa kwiseli F5 - indawo apho iziphumo zomsebenzi ziya kuboniswa
- Cofa kwiqhosha lomsebenzi wizard (fx) ukuze uvelise ibhokisi yencoko yencoko yomsebenzi
- Thayipha DCOUNT kwi- Khangela yefestile yomsebenzi phezulu kwibhokisi yencoko
- Cofa kwi- GO iqhosha ukukhangela umsebenzi
- Ibhokisi yencoko yababini ifanele ifumane i-DCOUNT kwaye uyibeke kwiWindows window
- Cofa Kulungile ukuvula ibhokisi yencoko yencoko ye-DCOUNT
07 ka 08
Ukugqiba iiArguments
- Cofa kwiNgcaciso yedatha yebhokisi yencoko
- Thayipha igama lohlu lokubhalisa kumgca
- Cofa kwiNgcambu yomgca kwibhokisi yencoko
- Thayipha igama lenkalo "Unyaka" kumgca - qi niseka ukuba ufaka amanqaku okucaphuna
- Cofa kwiNqakrazo yomgca webhokisi yencoko
- Phakamisa iiseli zeD2 kwiF3 kwishidi lokusebenzela ukufaka uluhlu
- Cofa u-OK ukuvala ibhokisi yencoko yebhokisi ye-DCOUNT uze uqedele umsebenzi
- Impendulo yesi-3 ifanele ivele kwiseli yeF5 kuba iirekhodi ezintathu kuphela - ezikumqolo 7, 10, no-13-zibonisa umfundi njengabhalisiwe kunyaka wokuqala lwenkqubo
- Xa ucofa kwiseli F5 umsebenzi opheleleyo
= DCOUNT (Ubhaliso, "Unyaka", i-D2: F3) ibonakala kwifom yefomula ngaphezu kwephepha lokusebenzela
Qaphela: Ukuba sifuna ukufumana inani elipheleleyo labafundi ababhalisile, singasebenzisa umsebenzi oqhelekileyo we-COUNT, kuba asikho mfuneko yokucacisa imigaqo yokunciphisa ukuba yeyiphi idatha esetyenziswa ngumsebenzi.
08 ka 08
Iimpazamo zeSebenzi zeDatabase
#Value : Ivela kuninzi xa amagama omhlaba engabandakanywa kwingxabano yedatha.
Ngokomzekelo ongentla, qiniseka ukuba amagama ensimi kwii-D6: F6 zifakiwe kwi- Registration range.