Ungabala kanjani inani lamaseli anombhalo ku-Excel

Kwesinye isikhathi kuba nesidingo sokuqonda ukuthi mangaki amaseli aqukethe noma yiluphi ulwazi. Iqoqo lamathuluzi le-Excel linesethi yemisebenzi ekuvumela ukuthi ufeze lo msebenzi. Masibonise ngokucacile, ngezithombe-skrini, okufanele kwenziwe kulokhu. Sizohlaziya izimo ezijwayelekile kakhulu lapho kudingekile ukwenza ukuzimisela kwenani lamaseli ngolwazi kanye nezindlela ezifanele kakhulu kuwo.

Ungabala kanjani inani lamaseli ku-Excel

Imaphi amathuluzi angatholwa umsebenzisi uma efuna ukunquma ukuthi mangaki amaseli akhona?

1. Ikhawunta ekhethekile ekhombisa inani kubha yesimo.
2. I-arsenal yemisebenzi enquma inani lamaseli aqukethe ulwazi lohlobo oluthile.

Umsebenzisi angakhetha ukuthi iyiphi indlela azoyisebenzisa ngokusekelwe esimweni esikuso. Ngaphezu kwalokho, ungasebenzisa amathuluzi amaningana ngesikhathi esisodwa ukuxazulula izinkinga eziyinkimbinkimbi.

Indlela 1. Ukubala Iseli Ngebha Yesimo

Lena indlela elula yokuthola inombolo yamaseli afaka noma yiluphi ulwazi. Ngakwesokudla sebha yomumo kunesibali. Ingatholakala kancane kwesokunxele sezinkinobho zokushintsha izindlela zokubonisa ku-Excel. Le nkomba ayiboniswa uma kungekho nto ekhethiwe noma awekho amaseli aqukethe amanani. Futhi ayivezwa uma kuneseli elilodwa kuphela elinjalo. Kodwa uma ukhetha amaseli amabili angenalutho, ikhawunta izovela ngokushesha, futhi ungakwazi ukunquma inani lamaseli aqukethe ulwazi.

Naphezu kweqiniso lokuthi lesi sibali sivuliwe kuzilungiselelo "zefekthri", kwezinye izimo kungase kungabi. Lokhu kwenzeka uma omunye umsebenzisi eke wayikhubaza ngaphambilini. Ukuze wenze lokhu, kufanele ushayele imenyu yokuqukethwe yebha yesimo futhi wenze kusebenze into ethi "Ubuningi". Inkomba izophinde ivele ngemva kwalezi zinyathelo.

Indlela yesi-2: Bala amaseli ngomsebenzi we-COUNTA

I-Operator SCHETZ - indlela elula kakhulu yokubala inani lamaseli lapho kukhona idatha ethile, uma udinga ukubhala umphumela wokugcina kwenye iseli noma uwusebenzise ezibalweni zomunye u-opharetha. Inzuzo yokusebenzisa umsebenzi ukuthi asikho isidingo sokuvakashela kabusha inombolo yamaseli isikhathi ngasinye lapho kukhona ulwazi oluthile uma ububanzi bushintsha. Okuqukethwe (inani elibuyiswe ifomula) kuzoshintsha ngokuzenzakalelayo. Kwenziwa kanjani?

1. Okokuqala, kudingeka sikhethe iseli lapho kuzobhalwa khona inombolo yokugcina yamaseli agcwalisiwe. Thola inkinobho ethi "Faka Umsebenzi" bese uchofoza.
2. Uma sesiqedele izinyathelo ezingenhla, kuzovela ibhokisi lengxoxo lapho sidinga ukukhetha umsebenzi wethu. Ngemuva kokukhetha, chofoza inkinobho ethi "OK".
3. Okulandelayo, ibhokisi lokufaka ama-agumenti lizovela. Awuhlu lwamaseli noma ngokuqondile amakheli alawo maseli okufanele ahlaziywe ukuze ahlale kuwo futhi kunqunywe inombolo. Kunezindlela ezimbili zokufaka uhla: okwenziwa ngesandla kanye ne-othomathikhi. Ukuze ungenzi iphutha ekucaciseni amakheli eseli, kungcono ukhethe ububanzi obufanele ngemva kokuchofoza inkambu yokufaka idatha. Uma amaseli, inani okufanele linqunywe, atholakala kude, kubalulekile ukuwafaka ngokuhlukana, ugcwalise izinkambu "Value2", "Value3" njalonjalo.
4. Chofoza OK.

Kungenzeka futhi ukufaka lo msebenzi ngesandla. Isakhiwo somsebenzi: =COUNTA(value1,value2,…).

Ngemva kokufaka le fomula, cindezela ukhiye wokufaka, futhi uhlelo luzokwenza ngokuzenzakalelayo zonke izibalo ezidingekayo. Izobonisa umphumela kuseli efanayo lapho ifomula ibhalwe khona.

Indlela 3. COUNT umsebenzi wokubala amaseli

Kukhona omunye u-opharetha oklanyelwe ukuthola inani lamaseli. Kodwa umehluko wayo ku-opharetha wangaphambili ukuthi iyakwazi ukubala kuphela lawo maseli okunezinombolo kuwo. Indlela yokusebenzisa lolu hlelo lokusebenza?

1. Ngokufanayo nesimo sefomula yangaphambilini, khetha iseli lapho ifomula izobhalwa khona bese uvula Isilekeleli Somsebenzi. Bese ukhetha "ACCOUNT" futhi uqinisekise izenzo zakho (chofoza kwesokunxele inkinobho OK).
2. Okulandelayo, iwindi lokufaka izimpikiswano liyavela. Ziyafana nendlela yangaphambilini. Udinga ukucacisa noma ububanzi (ungaba nokumbalwa), noma izixhumanisi zamaseli. Chofoza "KULUNGILE".

I-syntax ifana neyangaphambili. Ngakho-ke, uma udinga ukuyifaka ngesandla, udinga ukubhala umugqa olandelayo wekhodi: =COUNT(inani1, inani2,…).

Khona-ke, endaweni lapho kubhalwe khona ifomula, inani lamaseli okunezinombolo lizovela.

Indlela 4. COUNT umsebenzi

Ngalo msebenzi, umsebenzisi akakwazi ukunquma kuphela inani lamaseli lapho kukhona idatha yezinombolo, kodwa nalawo ahlangabezana nemibandela ethile. Isibonelo, uma umbandela uwukuthi >50, khona-ke yilawo maseli kuphela lapho kubhalwe inombolo enkulu kunamashumi amahlanu azocatshangelwa. Ungacacisa noma yimiphi eminye imibandela, okuhlanganisa enengqondo. Ukulandelana kwezenzo ngokujwayelekile kufana nezindlela ezimbili zangaphambilini, ikakhulukazi ezigabeni zokuqala. Udinga ukushayela iwizadi yomsebenzi, faka izimpikiswano:

1. Ibanga. Leli isethi yamaseli lapho ukuhlolwa nokubala kuzokwenziwa khona.
2. Umbandela. Lesi yisimo lapho amaseli kububanzi azohlolwa kuso.

I-syntax yokufaka mathupha: =COUNTIF(ububanzi, imibandela).

Uhlelo luzokwenza izibalo futhi luzibonise kuseli lapho kuzobhalwa khona ifomula.

Indlela yesi-5: Umsebenzi we-COUNTIFS wokubala Amaseli

Umsebenzi ofana nowangaphambilini, uhlinzeka kuphela ngokuhlolwa ngemibandela embalwa. Izimpikiswano ziyabonakala kulesi sithombe-skrini.

Ngakho-ke, ngokufaka ngesandla, i-syntax ithi: =COUNTIFS(condition_range1, condition1, condition_range2, condition2,…).

Ungabala kanjani inani lamaseli anombhalo ngaphakathi kobubanzi

Ukuze ubale inani eliphelele lamaseli anombhalo ngaphakathi, kufanele ufake umsebenzi njengobubanzi -ETEXT(ibanga lokubala). Umsebenzi lapho ububanzi bufakwe khona ungaba yinoma yikuphi kokungenhla. Ngokwesibonelo, ungasebenzisa umsebenzi SCHETZ, lapho esikhundleni sobubanzi sifaka umsebenzi obhekisela kulobu bubanzi njengempikiswano. Ngakho-ke, akukho lutho olunzima ekunqumeni inani lamaseli anombhalo. Kulula nakakhulu ukubala ukuthi mangaki amaseli aqukethe inani.