Ngezinye izikhathi kubalulekile ukuthola ukuthi zingaki izinhlamvu eziqukethwe esitokisini esithile. Yiqiniso, ungakwazi ukumane ubale ngesandla, kodwa yini okufanele uyenze uma kunezinto eziningi, futhi ukubala kufanele kwenziwe ngokuqukethwe okuguquguqukayo njalo ngezinjongo ezithile? Masifunde ukuthi singabala kanjani inani labalingiswa ku-Excel.
Ukubala izinhlamvu
Ukuze uhlamvu ubale ku-Excel, kunomsebenzi okhethekile obizwa "DLSTR". Kungenxa ngosizo lwazo ukuthi ungafaka izibonakaliso kwisici esithile sekhasi. Kunezindlela eziningana zokuzisebenzisa.
Indlela 1: izinhlamvu zokubala
Ukuze ubale zonke izinhlamvu ezikhona kuseli, sebenzisa umsebenzi DLSTR, okushoyo, "ngendlela ehlanzekile".
- Khetha ishidi leshidi lapho umphumela wokubala kufanele uboniswe khona. Chofoza inkinobho "Faka umsebenzi"itholakala phezulu kwefasitela ngakwesobunxele kwibha yefomula.
- Iqala umsebenzi wizard. Ufuna igama kulo DLSTR bese uchofoza inkinobho "Kulungile".
- Ukulandela lokhu kuvulwa kwewindi lezingxabano. Lo msebenzi unempikiswano eyodwa kuphela - ikheli leseli elithile. Ngaphezu kwalokho, kufanele kuqashelwe ukuthi, ngokungafani namanye ama-opharetha amaningi, lona awusekeli ukufaka izingqikithi kumaseli amaningana noma ku-array. Ensimini "Umbhalo" ngesandla faka ikheli lesici lapho ofuna ukubala khona izinhlamvu. Ungakwenza ngokuhlukile, okuzoba lula kubasebenzisi. Setha isikhombisi enkampanini ye-argument bese uchofoza endaweni oyifunayo kushidi. Ngemuva kwalokho, ikheli layo lizovela ensimini. Uma idatha efakiwe, chofoza inkinobho "Kulungile".
- Njengoba ungabona, emva kwalokhu, umphumela wokubala inani labalingiswa uboniswa esikrinini.
Indlela 2: Bala izinhlamvu kukholomu
Ukuze ubale inamba yabalingiswa kukholomu noma kunoma yiluphi olunye uhla lwemininingwane, akudingekile ukubeka ifomula ngayinye ngayinye ngokwehlukana.
- Sifika ekhoneni elingaphansi kwesokudla leseli ngefomula. Uphawu lokukhethwa luvela. Bamba inkinobho yegundane lesokunxele bese uyidonsela endaweni efanayo lapho sifuna ukubala inani labalingiswa.
- Ifomula likopishwa phezu kobubanzi bonke. Umphumela ubonakala ngokushesha eshadini.
Isifundo: Indlela yokwenza ngokuzenzekelayo ku-Excel
Indlela 3: Bala amaseli amangqamuzana amaningi usebenzisa isamba semali
Njengoba kushiwo ngenhla, ingxabano yomqhubi DLSTR izixhumanisi kuphela zeseli eyodwa zingabonakala. Kodwa kuthiwani uma udinga ukubala inani lezinhlamvu eziningana zazo? Kulokhu, kuyinto elula kakhulu ukusebenzisa umsebenzi we-auto sum.
- Sibala inani lezinhlamvu kumakhalekhukhwini ngamunye, njengoba kuchazwe kunguqulo yangaphambilini.
- Khetha ibanga lapho kubalwa khona izinhlamvu, bese uchofoza inkinobho. "Inani"itholakala kuthebhu "Ikhaya" ebhokisini lesethingi Ukuhlela.
- Emva kwalokho, inani labalingiswa kuzo zonke izakhi lizoboniswa kuseli elihlukile eceleni kwebanga lokukhetha.
Isifundo: Indlela yokubala inani ku-Excel
Indlela 4: Ukubala izinhlamvu kumaseli amaningi usebenzisa umsebenzi
Kule ndlela engenhla, udinga ukufeza ngokushesha isibalo sento ngayinye ngokwehlukana bese ubala inani eliphelele labalingiswa kuwo wonke amaseli. Kodwa kukhona futhi okukhethwa kuzo zonke izibalo ezizokwenziwa ngenye yazo kuphela. Kulesi simo, udinga ukusebenzisa ifomula enhlanganisela usebenzisa opharetha SUM.
- Khetha ishidi leshidi lapho umphumela uzoboniswa khona. Faka ifomula kuyo ngokusho kwesifanekiso:
= SUM (DLSTR (cell_address1); DLSTR (cell_address2); ...) - Ngemuva kokusebenza ngamakheli azo zonke amaseli, inani labalingiswa ofuna ukubala, lingeniswe, chofoza inkinobho ENTER. Inani eliphelele labalingiswa liyaboniswa.
Njengoba ubona, kunezindlela eziningana zokubala inani labalingiswa kumaseli ngabanye, nenani lezinhlamvu kuzo zonke izakhi zobubanzi. Kuzo zonke izinketho, lo msebenzi uyenziwa usebenzisa umsebenzi DLSTR.
