I-Excel DSUM Umsebenzi Wezemfundo

Funda ukuthi ungaqoqa amarekhodi akhethiwe kuphela umsebenzi we-DSUM

Umsebenzi we-DSUM ungomunye wemisebenzi yedatha ye-Excel. Imisebenzi ye-Excel yedatha ikusiza uma usebenzisa i-Excel database. I-database ngokuvamile ithatha uhlobo lwetafula elikhulu lwedatha, lapho umugqa ngamunye etafuleni ugcina irekhodi ngalinye. Ikholomu ngayinye kuthebula lesipredishithi ligcina insimu ehlukile noma uhlobo lwamarekhodi ngayinye irekhodi.

Imisebenzi yedatha yemisebenzi yenza imisebenzi eyisisekelo, njengokubala, i-max, neyamaminithi, kodwa ivumela umsebenzisi ukuba acacise ukulinganisa, ukuze umsebenzi usebenze kumarekhodi akhethiwe kuphela. Amanye amarekhodi ase database ayakwaziswa.

01 ngo-02

Umsebenzi we-DSUM Uhlolojikelele kanye ne-Syntax

Umsebenzi we-DSUM usetshenziselwa ukufaka phezulu noma ukubeka inani lamanani kukholomu yedatha ehlangabezana nemigomo yokusetha.

I-DSUM Syntax ne-Arguments

I- syntax yomsebenzi we-DSUM yilezi:

= I-DSUM (i-database, field, criteria)

Lezi zizathu ezintathu ezidingekayo yizi:

• I-Database isebenza ububanzi bezinkomba ezigciniwe eziqukethe idatha. Amagama ensimu kumele afakwe ebangeni.
• Inkambu ikhombisa ukuthi iyiphi ikholomu noma insimu okufanele isetshenziswe umsebenzi ekubalweni kwayo. Faka ingxabano noma ngokuthayipha igama lesimu kuma-quotes, njenge- Radius , noma ufaka inombolo yekholomu, njenge-3.
• Imikhakha ibonisa 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 ka 02

Usebenzisa i-DSUM Function Tutorial ye-Excel

Bheka umfanekiso ohambisana nalesi sihloko njengoba usebenza ngokufundisa.

Lokhu kufundisa kuyasetshenziselwa ukuthola inani lemifino eqoqwe njengoba kubhalwe kukholomu yokukhiqiza yesithombe sesibonelo. Inqubo esetshenziselwa ukuhlunga idatha kulesi sibonelo yiluhlobo lomuthi we-maple.

Ukuze uthole inani lemifino eqoqwe kuphela emabalazweni amnyama nesiliva:

1. Faka ithebula lwedatha njengoba kuboniswa kusibonelo sesitfombe kumaseli A1 kuya ku-E11 wephepha lokusebenzela elingenalutho.
2. Kopisha amagama ensimu kumaseli A2 kuya ku-E2.
3. Namathisela amagama ensimu kumaseli A13 kuya ku-E13. Lezi zisetshenziselwa njengengxenye yempikiswano yeCriteria .

Ukukhetha i-Criteria

Ukuthola i-DSUM ibheke kuphela idatha yezihlahla ze-maple ezimnyama nezesiliva, faka amagama emithi ngaphansi kwegama le- Maple Tree field field.

Ukuze uthole idatha yezihlahla ezingaphezu kweyodwa, faka igama ngalinye lomuthi kumugqa ohlukile.

1. Esimeni A14, thayipha izinqubo, Black.
2. Esimeni A15, thayipha i- Silver criteria .
3. Esitokisini D16, thayipha i- Gallons ye-Sap ekhomba ukubonisa ulwazi umsebenzi we-DSUM owenzayo.

Ukubiza i-Database

Ukusebenzisa ububanzi obuqanjwe ngamabanga amakhulu yedatha njenge database akukwazi ukwenza kube lula ukufaka ingxabano emsebenzini, kodwa kungavimbela amaphutha abangelwa ukukhetha uhla olungalungile.

Amamitha afanekayo awusizo uma usebenzisa uhla olufanayo lwamaseli njalo ngezibalo noma uma udala amashadi noma amagrafu.

1. Gqamisa amaseli A2 kuya ku-E11 kushidi lokusebenzela ukuze ukhethe uhla.
2. Chofoza ebhokisini legama ngenhla ikholomu A kuphepha lokusebenzela.
3. Thayipha Izihlahla ebhokisini igama ukuze udale ububanzi obuqanjwe.
4. Cindezela ukhiye wokungena kwikhibhodi ukuqedela ukungena.

Vula i-DSUM Dialog Box

Ibhokisi lengxoxo lomsebenzi linikeza indlela elula yokufaka idatha ngayinye yeziphakamiso zomsebenzi.

Ukuvula ibhokisi lebhokisi leqembu lemininingwane yemisebenzi lenziwa ngokuchofoza inkinobho ye-Function Wizard (fx) esekelwe eceleni kwefomula yefomula ngaphezulu kwephepha lokusebenzela.

1. Chofoza kuseli E16 -indawo lapho imiphumela yomsebenzi izoboniswa khona.
2. Chofoza kusithonjana se- Function Wizard ukuletha ibhokisi lokufaka le- Function Faka .
3. Thayipha i- DSUM ekusesheni iwindi lomsebenzi phezulu kwebhokisi lengxoxo.
4. Chofoza inkinobho ye- GO ukucinga lo msebenzi.
5. Ibhokisi lebhokisi kumele lithole i-DSUM bese ulibeka ohlwini lweWindows.
6. Chofoza OK ukuze uvule ibhokisi lengxoxo ye-DSUM.

Ukugcwalisa iziphakamiso

1. Chofoza ku- Database database yebhokisi lengxoxo.
2. Thayipha igama lebanga Imithi emgqeni.
3. Chofoza ku- Field field yebhokisi lengxoxo.
4. Thayipha igama lomkhakha " Ukukhiqiza" emgqeni. Qinisekisa ukufaka amamaki okucaphuna.
5. Chofoza kulayini Wokuqondisa ebhokisini lengxoxo.
6. Hudula ukhethe amaseli A13 kuya ku-E15 kushidi lokufaka ukufaka ibanga.
7. Chofoza OK ukuze uvale ibhokisi lengxoxo ye-DSUM bese uqedela umsebenzi.
8. Impendulo engu- 152 , ekhombisa inani lamagremu omuncu oqoqwe emithini yemifula emnyama neyesiliva, kufanele ivele esitokisini E16.
9. Uma uchofoza ku-cell C7 , umsebenzi ophelele
   = I-DSUM (Imithi, "Ukukhiqiza", A13: E15) ibonakala kwibha yefomula ngaphezulu kwephepha lokusebenzela.

Ukuthola inani lemifino eqoqwe kuzo zonke izihlahla, ungasebenzisa umsebenzi we-SUM ovamile, ngoba awudingi ukucacisa ukulinganisa ukukhawulela ukuthi iyiphi idatha esetshenziswa ngomsebenzi.

Iphutha lomsebenzi wesisekelo sedatha

Iphutha le-#Value livela kaningi lapho amagama ensimu engekho ku-argument yedatha. Ngalesi sibonelo, qiniseka ukuthi amagama ensimu kumaseli A2: E2 afakwe emithini ebizwa ngokuthi yi- Trees .