Lapho wenza imisebenzi ethile ngenkathi usebenza netafula, kungadingeka ukubala amaseli agcwele imininingwane. I-Excel inikeza lokhu ngamathuluzi owakhelwe ngaphakathi. Ake sibheke ukuthi singayenza kanjani inqubo ebekiwe kulolu hlelo.
Ukubala amaseli
Ku-Excel, inani lamaseli agcwele angabonakala kusetshenziswa i-counter kubha yesimo noma imisebenzi ethile, ngayinye ebala izinto ezigcwaliswe ngohlobo oluthile lwedatha.
Indlela yoku-1: counter kubha yesimo
Indlela elula yokubala amaseli aqukethe idatha ukusebenzisa imininingwane kusuka kwikhawunta, ebekwe ohlangothini lwesokunene sebha yesimo ngakwesokunxele izinkinobho zokushintsha izindlela zokubuka ku-Excel. Ngenkathi ibanga liqokonyiswa eshidini lapho zonke izinto zingenalutho noma eyodwa kuphela iqukethe inani elithile, le nkomba ifihliwe. I-counter ivele ngokuzenzakalela lapho kukhethwa amaseli amabili noma amaningi angenalutho, futhi ngokushesha ikhombisa inani lawo emva kwegama "Ubuningi".
Kodwa, yize le counter inikwe amandla ngokuzenzakalela, futhi ilindela kuphela umsebenzisi ukugqamisa izinto ezithile, kwezinye izikhathi ingakhubazeka ngesandla. Lapho-ke umbuzo wokufakwa kwawo uyafaneleka. Ukuze wenze lokhu, chofoza kwesokudla kubha yesimo nakuhlu oluvelayo, hlola ibhokisi eliseduze "Ubuningi". Ngemuva kwalokho, i-counter izophinde iboniswe.
Indlela 2: umsebenzi we-COUNT
Inani lamaseli agcwele angabalwa kusetshenziswa umsebenzi ongu-COUNT. Ihluka ngendlela yangaphambilini ngoba ikuvumela ukuthi ulungiselele ukubalwa kwebanga elithile kuseli elihlukile. Okusho ukuthi, ukubuka ulwazi kuyo, indawo ngeke idinge ukwabiwa njalo.
- Khetha indawo lapho kuzobukiswa khona umphumela wokubala. Chofoza isithonjana "Faka umsebenzi".
- Iwindi le-Function Wizard liyavula. Sifuna into ohlwini I-SCHETZ. Ngemuva kokuqokonyiswa kwaleli gama, chofoza inkinobho "Kulungile".
- Iwindi lokuphikisana liyaqala. Izimpikiswano zalo msebenzi ziyizethenjwa zeselula. Isixhumanisi esiya ebangeni singasethwa ngesandla, kepha kungcono ukusetha isikhombisi ensimini "Inani1"lapho ufuna ukufaka idatha, bese ukhetha indawo ehambisanayo ephepheni. Uma ufuna ukubala amaseli agcwele emabangeni ambalwa ahlukaniswe komunye nomunye, khona-ke izixhumanisi zohlu lwesibili, lwesithathu nolulandelayo kufanele zifakwe emikhakheni ebizwa ngokuthi "Inani2", "Inani3" njll. Lapho yonke idatha ifakiwe. Chofoza inkinobho "Kulungile".
- Lo msebenzi futhi ungafakwa ngesandla kuseli noma umugqa wamafomula, unamathela kulokho okulandelayo:
= COUNT (inani1; inani2; ...) - Ngemuva kokuthi ifomula ifakiwe, uhlelo endaweni ekhethwe ngaphambilini lubonisa umphumela wokubala amaseli agcwalisiwe ebangeni elishiwo.
Indlela 3: Umsebenzi we-COUNT
Ngaphezu kwalokho, ukubala amaseli agcwele ku-Excel kukhona nesibalo sokusebenza. Ngokungafani nefomula yangaphambilini, ibala kuphela amaseli agcwele idatha yamanani.
- Njengasesimweni esedlule, khetha iseli lapho idatha izokhonjiswa khona futhi ngendlela efanayo gijima i-Function Wizard. Kuyo sikhetha opharetha enegama "I-ACCOUNT". Chofoza inkinobho "Kulungile".
- Iwindi lokuphikisana liyaqala. Izimpikiswano ziyafana nokusebenzisa indlela eyedlule. Indima yabo ibhekiselwa kumaseli. Sifaka izixhumanisi zemikhakha ephepheni lapho udinga khona ukubala inani lamaseli agcwele imininingwane yedatha. Cindezela inkinobho "Kulungile".
Ukuze kwethulwe ifomula ebhukwini, sinamathela kulokho okulandelayo:
= COUNT (inani1; inani2; ...) - Ngemuva kwalokho, endaweni lapho kufakwa khona ifomula, kuzovezwa inani lamaseli agcwele imininingwane yezinombolo.
Indlela 4: Umsebenzi we-COUNTIF
Lo msebenzi ukuvumela ukubala hhayi inani lamaseli agcwele izinkulumo zenombolo, kodwa kuphela lelo elihambisana nesimo esithile. Isibonelo, uma uhlela isimo "> 50", kuzobhekelwa kuphela lawo maseli aqukethe inani elingaphezulu kwenombolo 50. Ungasetha futhi amanani "<" (amancane), "" (angalingani), njll.
- Ngemuva kokuthi ukhethe iseli ukubonisa umphumela futhi wethule Umsebenzi Wizard, khetha ukungena "COUNTIF". Chofoza inkinobho "Kulungile".
- Iwindi lokuphikisana liyavula. Lo msebenzi unezimpikiswano ezimbili: ibanga lapho amaseli abalwa khona, nenqubo, okungukuthi, isimo esikhulume ngaso ngaphezulu. Ensimini "Ububanzi" faka izixhumanisi zendawo esetshenzisiwe, nasensimini "Indawo yokuhlala" faka imibandela. Ngemuva kwalokho chofoza inkinobho "Kulungile".
Okokufaka okwenziwa ngesandla, itemplate yilena elandelayo:
= COUNTIF (ibanga; inqubomgomo) - Ngemuva kwalokho, uhlelo lubala amaseli agcwalisiwe ebangeni elikhethiwe, elihambelana nesimo esibekiwe, futhi lizikhombise endaweni echazwe esigabeni sokuqala sale ndlela.
Indlela yesi-5: Umsebenzi we-COUNTIF
Isisebenzisi se-COUNTIF yinguqulo ethuthukisiwe yomsebenzi we-COUNTIF. Kuyasetshenziswa lapho udinga ukucacisa isimo sokuqhathanisa esingaphezu kwesisodwa samabanga ahlukile. Sekukonke, ungacacisa kuze kufike ezimweni eziyi-126.
- Sikhetha iseli lapho umphumela uzokhonjiswa khona bese usebenza i-Function Wizard. Sifuna into kuyo "COUNTILES". Khetha bese uchofoza inkinobho. "Kulungile".
- Iwindi lokuphikisana liyavula. Empeleni, izimpikiswano zomsebenzi ziyefana nezangaphambili - "Ububanzi" futhi "Isimo". Umehluko kuphela ukuthi kungaba nezinhla eziningi nezimo ezihambisanayo. Faka amakheli amabanga nezimo ezihambisanayo, bese uchofoza inkinobho "Kulungile".
I-syntax yalomsebenzi imi kanje:
= COUNTIME (isimo_range1; isimo1; isimo_range2; isimo2; ...) - Ngemuva kwalokho, uhlelo lokusebenza lubala amaseli agcwele amabanga ashiwo, ahambelana nemibandela esunguliwe. Umphumela uboniswa endaweni eyayimakwe kuyo ngaphambili.
Njengoba ukwazi ukubona, ukubalwa okulula kakhulu kwenombolo yamaseli agcwalisiwe ebangeni elikhethiwe kungabonakala kubha yesimo ye-Excel. Uma udinga ukubonisa umphumela endaweni ehlukile ephepheni, futhi nangaphezulu ukubala, ucabangela imibandela ethile, khona-ke kuleli cala imisebenzi ekhethekile izokusiza.
