Ngaba kufuneka ubale inani lezinto ezidibana nemeko ethile kuluhlu lwe-Excel? Le nkqubo inomdla wokubonelela ngeendlela ezahlukeneyo zokufikelela isiphelo. Nangona ezinye zihlala zinde okanye zintsonkothile ngakumbi kunabanye, umbono kukuthatha leyo isinika isiphumo esifunekayo phantsi kwendlela esenza sizive sikhululekile. Ngoko, Ukuqhubela phambili nomzekelo wokuqala, ukuba sifuna ukubala inani lezinto kuluhlu oluhlangabezana nemilinganiselo ethile, siya kukufundisa indlela yokusebenzisa umsebenzi we-COUNTIF kwi-Excel.
Lo msebenzi ikuvumela ukuba ubonise kwiprogram apho idatha ofuna ukuyibala kwaye yintoni imeko ekufuneka ihlangatyezwane nayo, ukuze kwimizuzwana embalwa ufumane inani olifunayo.
Yintoni umsebenzi COUNTIF osetyenziselwa ntoni?
Njengoko besitshilo ngaphambili, kwi-Excel kukho iindlela ezahlukeneyo zokufikelela kwisiphumo esifanayo. Nangona kunjalo, asingabo bonke abanikela ngale nto siyifunayo. Umzekelo, ukubala izinto kuluhlu yinto esinokuyifumana ngokulula ngokuzikhetha kwaye emazantsi ekunene kujongano siya kubona ukubala. Nangona kunjalo, imeko inokuba nzima kwaye iimfuno zingaya phambili, oko kukuthi, akufuneki ukubala uluhlu olupheleleyo, kodwa izinto ezithile. Kulapha ngeli xesha isidingo sokhetho olunikezela ngamathuba amakhulu luvela, kwaye kulapho i-protagonist yethu yanamhlanje ingena khona: umsebenzi we-COUNTIF.
Njengoko igama layo libonisa, i-COUNTIF ivumela ukuba sibale izinto zoluhlu lwedatha kuphela xa zihlangabezana nemilinganiselo okanye imeko esekwe ngaphambili. Ukongeza, inokuguquguquka kokuziqhelanisa neendawo ezinamanani okanye idatha yombhalo, ngoko sinokuyisebenzisa ukubala into esiyidingayo kumaxwebhu ethu.. Yinto eluncedo enokugcina ixesha elininzi kwimisebenzi yethu yemihla ngemihla ngeExcel. Okulandelayo, siza kuchaza indlela yokuyisebenzisa.
Uwusebenzisa njani umsebenzi COUNTIF?
Ukuchaza indlela yokusebenzisa umsebenzi we-COUNTIF, siya kuseka umzekelo ngoluhlu lwedatha apho kwikholamu enye sinomzekelo wesithuthi kwaye kwenye, umbala wayo.. Umsebenzi wethu uya kuba ukwazi inani lezithuthi ezibomvu ezivela etafileni usebenzisa umsebenzi we-COUNTIF.
Le fomyula ilula kakhulu ukuyisebenzisa, kuba isivakalisi sayo okanye indlela yokubhala ineemfuno ezimbini kuphela: uluhlu kunye nenqobo yokugweba.. Uluhlu yiseti yeeseli apho idatha esifuna ukuyibala ibekwe khona, kwaye inqobo yokugweba yimeko ekufuneka ihlangatyezwane nento ekufuneka iqwalaselwe ekubaleni. Ngaloo ndlela, ukuba sifuna ukubala, kumzekelo wethu, ukuba zininzi kangakanani iinqwelo ezibomvu, ikhrayitheriya iya kuba ligama elithi "Red".
Ukwenza oku, cofa kabini iseli engenanto kwiphepha lakho le-Excel kwaye uchwetheze oku kulandelayo:
=COUNTIF(E5:E54, "Bomvu")
Idatha yokuqala xa uvula i-parentheses ibhekisela kuluhlu apho idatha esifuna ukuyibala, kwaye ke sinegama elithi "Red" kumanqaku okucaphula..
Iikhrayitheriya zifakwe kwiingcaphuno xa ujongana nesicatshulwa; ukuba ngamanani, akuyi kuba yimfuneko ukuwasebenzisa. Nje ukuba uvale i-parenthesis, betha u-enter kwaye ngoko nangoko uya kufumana inani lezithuthi ezibomvu ezidwelisiweyo. Ungaphinda le nkqubo inye ngayo yonke imibala kwaye uya kwazi ukuba bangaphi na nganye.
Isiphelo
Umsebenzi we-COUNTIF ungenye yezo zixhobo ekufuneka sihlale sinazo kwi-arsenal yethu ye-Excel, njengoko isinceda kwiimeko ezinobungakanani obukhulu kunye nencinci yedatha.. Umsebenzi wokubala unokuba ngumngeni xa inani leezakhi liphezulu kwaye kwakhona, kukho iimfuno ezithile, ezinjengokufumana isixa esichanekileyo sohlobo oluthile. Nangona kunjalo, i-COUNTIF yenza lula yonke into ngokubonisa nje ukuba iphi idatha kwaye yeyiphi esifuna ukuyibala.
Kukho iimeko ezifanelekileyo zokusebenzisa eli nqaku, kwaye ukusetyenzwa kwesaveyi yenye yazo.. Kuya kukwanela ukuthatha iziphumo zakho kwi-Excel kwaye kwimizuzwana embalwa uya kukwazi ukumisela inani lezihlandlo ukhetho oluthile olukhethiweyo. Ukuyenza ngesandla kuyakuthatha ixesha elininzi, endaweni yoko ukusebenzisa i COUNTIF umsebenzi ujika lo msebenzi ube yimizuzwana embalwa.
Umsebenzi we-COUNTIF awukhawulelwanga kuphela ekubaleni izinto kwikholamu enye. Ikwakuvumela ukuba uchaze uluhlu lwee-multidimensional, okuthetha ukuba ungazibala izinto kwiikholamu ezininzi nakwispredishithi ezahlukeneyo.
Eyona nto ingcono, awudingi ukuba yingcali ye-Excel ukuze usebenzise umsebenzi we-COUNTIF.. Ngokucela iimfuno ezimbini kuphela, ezingenzima kwaphela, isinika iziphumo ezikhawulezayo kunye nethuba elincinci lempazamo. Ngoko ke, ukuba uzifumana uphambi kwencwadi enedatha eninzi kwaye kufuneka ukwazi ubuninzi kunye neendlela ezithile, unganqikazi ukusebenzisa le fomyula eya kuhlangabezana neemfuno zakho ngokufanelekileyo.