I-COUNTIF ibuyisela inani elilinganiselwe ebangeni elithile
Umsebenzi we- COUNTIF uhlanganisa umsebenzi we- IF nomsebenzi COUNT kuma-Google AmaSpredishithi. Le nhlanganisela ikuvumela ukuthi ubale inani lezinombolo ezithile zedatha elitholakala ebangeni elikhethiwe lamaseli ahlangabezana nesilinganiso esisodwa, esicacisiwe. Nansi indlela umsebenzi osebenza ngayo:
- Ingxenye ye- IF yomsebenzi inquma ukuthi iyiphi idatha ehlangabezana nomgomo ocacisiwe.
- Ingxenye engu- COUNT yomsebenzi iphelele inani lamaseli ahlangabezana nomgomo.
I-COUNTIF Function & # 39; s i-Syntax ne-Arguments
I- syntax yomsebenzi ibhekisela kokuhlelwa komsebenzi futhi ihlanganisa igama lomsebenzi, amabakaki, abahlukanisi be-comma kanye nezimpikiswano . I-syntax yomsebenzi we-COUNTIF yi:
= COUNTIF (ibanga, umgogodla)
Ububanzi yiqembu lamaseli umsebenzi ozowuhlola. Umgogodla unquma ukuthi iseli elikhonjisiwe kuphikisana lobubanzi libalwe noma cha. Umgomo ungaba:
- Inombolo.
- Ukubhekisela kweseli endaweni yedatha kwifomu lokusebenzela, njenge-B12.
- Inkulumo, njenge-100, "<= 1000" noma "<>" & B12.
- Idatha yombhalo noma izintambo zombhalo , njenge "Drapes."
Uma i-argument yobubanzi iqukethe izinombolo:
- I- opharetha yokuqhathanisa njenge > (enkulu kunaleyo), <= (ngaphansi noma elinganayo), noma <> (engalingani) ingasetshenziswa enkulumweni futhi iseli ngalinye ebangeni lihlolwe ukuze libone uma lihlangabezana nomgomo .
- Ngokwemigomo yokufuna amanani alinganayo, isibonakaliso esifanayo asidingi ukuba sifakwe kule nkulumo, futhi inani alidingi ukuba lifakwe emamaki okucaphuna. Isibonelo, i-100 ingasetshenziselwa ukuphikisana komgomo esikhundleni se- "= 100" nakuba bobabili bazosebenza.
- Ngezimpawu ezingalingani ezingafaki izingcaphuno zeseli, yonke inkulumo kufanele ifakwe emamaki okucaphuna kabili , njenge "<= 1000"
- Ngamazwi asebenzisa ukuqhathanisa ama-operator nezinkomba zochungechunge, izingqikithi zeseli azihlanganisiwe kumamaki okucaphuna kabili, njenge "<>" & B12 noma "<=" & C12.
- Ngamazwi asebenzisa ukuqhathanisa ama-operator nezinkomba zocingo, u-opharetha wokuqhathanisa ujoyine ireferensi yeseli esebenzisa i-ampersand ( & ), oyinhlamvu yomncintiswano ku-Excel nama-Google AmaSpredishithi, njenge "<>" & B12 noma "<=" & C12.
Uma i-argument yobubanzi iqukethe idatha yombhalo:
- Izintambo zombhalo kufanele zifakwe emamaki okucaphuna kabili, njengokuthi "i-drapes."
- Imicu yombhalo ingaqukatha ? futhi * izinhlamvu zasendle ukufanisa eyodwa (?) noma amaningi (*) abalingiswa ezixubile.
- Ukufanisa okwenziwe? noma *, ngaphambi kwalezi zinhlamvu nge- tilde efana ne- ~? futhi ~ *.
COUNTIF Izibonelo Zezici
Njengoba kuboniswe esithombeni esihambisana nalesi sihloko, umsebenzi we-COUNTIF usetshenziselwa ukuthola inombolo yamaseli wedatha kukholomu A efanisa izinqubo ezihlukahlukene. Imiphumela yefomula ye-COUNTIF iboniswa kukholomu B futhi ifomula ngokwayo iboniswa kukholomu C.
- Imigqa emihlanu yokuqala yalesi sibonelo inombhalo wombhalo wempikiswano yomgomo womsebenzi futhi isebenzise amaseli A2 kuya ku-A6 kumbono wobubanzi.
- Imigqa emihlanu yokugcina inedatha yenombolo yezingxabano zomgomo.
Ukufaka i-COUNT Umsebenzi
I-Google AmaSpredishithi ayisebenzisi amabhokisi okuxoxa ukuze ufake izingqinamba zomsebenzi onjengoba uthola ku-Excel. Esikhundleni salokho, inebhokisi elikhombisa ukuzenzekelayo eliphambuka njengoba igama lomsebenzi lifakwe esitokisini. Izinyathelo ezingezansi imininingwane efaka umsebenzi we-COUNTIF nezimpikiswano zawo ezisefayilini B11 yesithombe sesibonelo. Kule seli, COUNTIF isesha u-A7 kuya ku-A11 ngezinombolo ezingaphansi noma ezilingana no-100,000.
Ukufaka umsebenzi we-COUNTIF nezimpikiswano zawo njengoba kuboniswa esitokisini B11 somfanekiso:
- Chofoza kuseli B11 ukwenza kube iseli elisebenzayo . Yilapho imiphumela yomsebenzi we-COUNTIF izoboniswa.
- Thayipha uphawu olulinganayo ( = ) olulandelwe igama lomkhandlu wokusebenza.
- Njengoba uthayipha, ibhokisi eliphakamisa ngokuzenzakalelayo livela ngamagama kanye ne-syntax yemisebenzi eqala ngencwadi C.
- Uma igama COUNTIF livela ebhokisini, cindezela ukhiye we- Enter ekhibhodi ukuze ufake igama lomsebenzi bese uvula ibakaki nxazonke esitokisini B11.
- Qinisekisa amaseli A7 kuya ku-A11 ukuze uwafake njengengxabano yomsebenzi womsebenzi.
- Thayipha i- comma ukuze usebenze njengohluli phakathi kobubanzi nezimpikiswano zomgomo.
- Ngemuva kokuhlaziya, thayipha inkulumo ethi "<=" & C12 ukuyifaka njengengxabano yomgomo.
- Cindezela ukhiye wokungena kwikhibhodi ukufaka ibhakha lokuvala lokuvala bese uqedela umsebenzi.
- Impendulo 4 kumele ivele esitokisini B11 ngoba zonke izingqamuzana ezine ezingxabanweni ezahlukene ziqukethe izinombolo ezingaphansi noma ezilingana no-100,000.
- Uma uchofoza ku- cell B11 , ifomula eqediwe = isigaba (A7: A10, "<=" & C12 ivela kubha yamasombulu ngaphezulu kwephepha lokusebenzela .