Umsebenzi we-DCOUNT ungenye yemisebenzi yedatha ye-Excel. Leli qembu lemisebenzi lenzelwe ukwenza kube lula ukufingqa ulwazi kusuka kumatafula amakhulu yedatha. Benza lokhu ngokubuyisela ulwazi oluthile olusekelwe kumgomo owodwa noma ngaphezulu okhethwe umsebenzisi. Umsebenzi we-DCOUNT ungasetshenziselwa ukuphelele inani lamakholomu kukholomu yedatha ehlangabezana nemigomo yokusetha.
01 ngo-08
I-DCOUNT i-Syntax ne-Arguments
Okuqondene nomsebenzi we-DCOUNT ngu:
= DCOUNT (idatha yedatha, indawo, criteria)
Yonke imisebenzi yedatha inezimpikiswano ezintathu ezifanayo:
- Idatha : (edingekayo) Icacisa ububanzi bezinkomba ezigciniwe eziqukethe idatha. Amagama ensimu kumele afakwe ebangeni.
- Insimu : (edingekayo) Ibonisa ukuthi iyiphi ikholomu noma insimu okufanele isetshenziswe umsebenzi ekubalweni kwayo. Faka ingxabano noma ngokuthayipha igama lesimu kumaphuzu - njenge "Radius" - noma faka inombolo yekholomu - efana no-3.
- Imigomo : (edingekayo) Uhlela ububanzi bamaseli aqukethe izimo ezichazwe umsebenzisi. Ububanzi kumele bubandakanye okungenani igama elilodwa lesimu kusuka ku-database futhi okungenani enye ireferensi yeseli ekhombisa isimo okufanele sihlolwe ngumsebenzi.
02 ngo-08
Isibonelo Ukusebenzisa i-DCOUNT Umsebenzi we-Excel - Ukufanisa ikhamera elilodwa
Chofoza kusithombe esingenhla ukuze ubone umbono omkhulu ngalesi sibonelo.
Lesi sibonelo sizosebenzisa i- DCOUNT ukuthola inani eliphelele labafundi ababhalisile ngonyaka wokuqala wehlelo lwabo lwekolishi.
03 ngo-08
Ukufaka idatha yokufundisa
Qaphela: Ukufundisa akubandakanyi izinyathelo zokufometha. Ulwazi olukhethwa kukho lokufometha kweshidi lokusebenza luyatholakala kule Tifundvo Eyisisekelo Yokufometha I- Excel .
- Faka ithebula lwedatha njengoba kuboniswa esithombeni ngenhla kumaseli D1 kuya ku-F15
- Shiya iselula F5 ingenalutho - yilapho i-formula ye-DCOUNT izotholakala khona
- Amagama endle kumaseli D2 kuya ku-F2 azosetshenziselwa njengengxenye yengxabano yomsebenzi weCriteria
04 ngo-08
Ukukhetha i-Criteria
Ukuze uthole i-DCOUNT ukubukeka kuphela kwedatha yabafundi bonyaka wokuqala sifaka inombolo engu- 1 ngaphansi kwegama lomkhakha wonyaka ngo-3.
- Esitokisini, i-F3 yenza uhlobo lwe-criteria 1
- Esikhathini se-E5 thayipha isihloko esiphezulu : ukukhombisa ulwazi esizoyithola nge-DCOUNT
05 ka-08
Ukubiza i-Database
Ukusebenzisa uhla olubizwa ngokuthi yizinhlu ezinkulu zemininingwane efana nedatha angeke yenza kube lula ukufaka le mpikiswano emsebenzini, kodwa kungavimbela amaphutha abangelwa ukukhetha ibanga elingalungile.
Amanothi aqanjwe abalulekile kakhulu uma usebenzisa uhla olufanayo lwamaseli njalo ngezibalo noma uma udala amashadi noma amagrafu.
- Gqamisa amaseli D6 kuya ku-F15 ekhasini lokusebenzela ukuze ukhethe uhla
- Chofoza ebhokisini legama ngenhla ikholomu A kuphepha lokusebenzela
- Thayipha ukubhaliswa ebhokisini legama ukuze udale ububanzi obuqanjwe
- Cindezela ukhiye wokungena kwikhibhodi ukuqedela ukungena
06 ka-08
Kuvulwa i-DCOUNT Dialog Box
Ibhokisi lengxoxo lomsebenzi linikeza indlela elula yokufaka idatha ngayinye yeziphakamiso zomsebenzi.
Ukuvula ibhokisi lebhokisi leqembu lemininingwane yedatha lenziwa ngokuchofoza inkinobho yomsebenzi wizard (fx) esekelwe eceleni kwebha yefomula ngaphezu kwephepha lokusebenzela - bheka isithombe ngenhla.
- Chofoza kuseli F5 - indawo lapho imiphumela yomsebenzi izoboniswa khona
- Chofoza ku- inkinobho ye-wizard inkinobho (fx) ukuze ukhiphe ibhokisi lengxoxo ye- Function Faka
- Thayipha i- DCOUNT ku- Usesho lwewindi lomsebenzi phezulu ebhokisini lengxoxo
- Chofoza inkinobho ye- GO ukucinga lo msebenzi
- Ibhokisi lebhokisi kumele lithole i-DCOUNT bese ulibhala ohlwini lweWindows
- Chofoza OK ukuze uvule ibhokisi lengxoxo ye-DCOUNT
07 ngo-08
Ukugcwalisa iziphakamiso
- Chofoza ku- Database database yebhokisi lengxoxo
- Thayipha igama lebanga lokubhalisa emgqeni
- Chofoza ku- Field field yebhokisi lengxoxo
- Thayipha igama lenkambu elithi "Unyaka" emgqeni - qiniseka ukufaka amamaki okucaphuna
- Chofoza kulayini Wokuqondisa ebhokisini lengxoxo
- Qinisekisa amaseli D2 kuya ku-F3 ekhasini lokusebenzela ukuze ungene ebangeni
- Chofoza OK ukuze uvale ibhokisi lengxoxo ye-DCOUNT bese uqedela umsebenzi
- Impendulo yesi-3 kufanele ivele esitokisini F5 kusukela kumarekhodi amathathu kuphela - lawo asemigqeni engu-7, 10, no-13 - abonisa ukuthi umfundi ubhalisile ngonyaka wokuqala wenhlelo yabo
- Uma uchofoza ku-cell F5 umsebenzi ophelele
= DCOUNT (Ukubhalisa, "Unyaka", i-D2: F3) ibonakala kwibha yefomula ngaphezulu kwephepha lokusebenzela
Qaphela: Uma sifuna ukuthola inani labafundi ababhalisile, singasebenzisa umsebenzi ojwayelekile we-COUNT, ngoba akudingeki sicacise izindlela zokukhawulela ukuthi iyiphi idatha esetshenziswe umsebenzi.
08 ngo-08
Amaphutha Okusebenza Nge-Database
I-#Value : Ivela kakhulu kaningi uma amagama ensimu engakafakiwe ku-argument yedatha.
Ngesibonelo esingenhla, qiniseka ukuthi amagama ensimu emafelini D6: F6 afakwe ku- Registration range.