I-COUNTIF ibuyisela inani elimiselweyo kwicandelo elithile
Umsebenzi we- COUNTIF udibanisa umsebenzi we- IF kunye nomsebenzi we-COUNT kwi-Google AmaSpredishithi. Le nhlanganisela ikuvumela ukuba ubale inani lamanye amaxesha iinkcukacha ezithile ezifunyenweyo kwinqanaba elikhethiweyo leeseli ezidibana nomlinganiselo owodwa. Nantsi indlela umsebenzi usebenza ngayo:
- ISIGABA se- IF somsebenzi sigqiba ukuba yeyiphi idilesi edibana ne-criterion echaziweyo.
- Icandelo le- COUNT lomsebenzi lilonke inani leeseli ezidibana nomqathango.
Umsebenzi we-COUNTIF kunye ne-Syntax kunye neArguments
I- syntax yomsebenzi ibhekisela kwisakhiwo somsebenzi kwaye iquka igama lomsebenzi, amabakaki, abahluli be-comma kunye neengxabano . I-syntax yomsebenzi we-COUNTIF yi:
= COUNTIF (ububanzi, umlinganiselo)
Uluhlu liqela leeseli umsebenzi ukukhangela. Umqathango ugqiba ukuba iseli echongiweyo kwingxabano yoluhlu ibalwa okanye cha. Umqathango unoku:
- Inombolo.
- Isalathiso seseli kwindawo yokusebenza kwiphepha lokusebenzela, njengeB12.
- Ibinzana, njenge-100, "<= 1000" okanye "<>" & B12.
- Idata yombhalo okanye uchungechunge lwetekisi , njenge "Drape."
Ukuba ingxabano yoluhlu iqulethe iinombolo:
- Uluhlu loqhathaniso olunjenge > (lukhulu kune), <= (ngaphantsi okanye elilinganayo), okanye <> (lingalingani na) lingasetyenziswe kwintetho kunye nesinye iseli kwinqanaba lihlolwe ukuba libone ukuba lihlangabezana nekhrayithi .
- Ngokomlinganiselo wokukhangela amanani alinganayo, uphawu olulinganayo alufuneki ukuba lufakwe kwiibinzana, kwaye ixabiso alifuneki ukuba lifakwe kumanqaku okucaphuna. Ngokomzekelo, i-100 ingasetyenziselwa ingxabano yekrameter esikhundleni sokuba "= 100" nangona bobabini baya kusebenza.
- Ngamazwi angalinganiyo angafaki iinkcukacha zeseli, lonke ibinzana kufuneka lifakwe kwiimpawu zokucaphulwa kabini , ezifana ne "<= = 1000"
- Ngamazwi asetyenziswa abasebenzisi bokuqhathanisa kunye neenkcukacha zeseli, ukuboniswa kweeseli akufakwe kwiimpawu zokucaphulwa kabini, njenge "<>" & B12 okanye "<=" & C12.
- Ngamazwi usebenzisa abalinganiswa beefayili kunye neeferensi zeselfayile, umsebenzisi othelekiso uhlanganiswe neselferensi yeseli esebenzisa i-ampersand ( & ), oyimpawu yokuxubusha kwi-Excel kunye ne-Google AmaSpredishithi, njenge "<>" & B12 okanye "<=" & C12.
Ukuba ingxabano yoluhlu luqukethe idatha yombhalo:
- Iimpawu zombhalo kufuneka zifakwe kwiimpawu zokucaphulwa kabini, ezifana "ne-drapes."
- Imiqhosha yombhalo ingaba nayo ? kunye nezinhlamvu ze-wildcard ukufanisa enye (?) okanye ezininzi (*) ezilandelanayo.
- Ukufanisa okwenene? okanye *, landela aba bantu nge- tilde ezifana ~? kunye ~ *.
COUNTIF ImiSebenzi YemiSebenzi
Njengoko kuboniswe kumfanekiso ohamba kunye nale nqaku, umsebenzi we-COUNTIF usetyenziselwa ukufumana inani leeseli zedatha kwikholam A efanisa imilinganiselo eyahlukeneyo. Iziphumo zefomula ze-COUNTIF ziboniswe kwikholam B kunye nefomula ngokwayo iboniswe kwikholam C.
- Imiqolo yokuqala yesihlanu yomzekelo ineenkcukacha zetekisi yenkcazo yomsebenzi we-criterion kwaye isebenzise iiseli A2 ukuya ku-A6 kwiingxabano zamanqanaba.
- Imigangatho emihlanu edlulileyo idibanise idatha yeengxabano zeempikiswano.
Ukufaka i-COUNT Umsebenzi
AmaSpredishithi eGoogle ayisebenzisi ibhokisi yencoko yababini yokufaka iingxoxo zomsebenzi onjengewe-Excel. Endaweni yoko, inebhokisi ephakanyiswa yi-auto ephakamisa njengoko igama lomsebenzi lifakwe kwiseli. Amanyathelo angaphantsi kweenkcukacha angena kumsebenzi we-COUNTIF kunye neziphakamiso zayo ezikwiseli B11 yomzekeliso womfanekiso. Kule seli, COUNTIF isesha u-A7 ukuya ku-A11 ngamanani angaphantsi okanye alingana no-100,000.
Ukufaka umsebenzi we-COUNTIF kunye neengxabano zayo njengoko kuboniswe kwiseli B11 yomfanekiso:
- Cofa kwifowuni B11 ukuze wenze iseli esebenzayo . Le yilapho iziphumo zomsebenzi we-COUNTIF ziza kuboniswa.
- Thayipha uphawu olulinganayo ( = ) olulandelwe igama lomsebenzi webhunga.
- Njengoko uthayipha, ibhokisi ye-auto-suggestion ibonakala ngamagama kunye ne-syntax yemisebenzi eqala ngeleta C.
- Xa igama COUNTIF livela kwibhokisi, cinezela iqhosha lokungena kwikhibhodi ukungena igama lomsebenzi kwaye uvule ibhoksi ejikelezayo kwi-cell B11.
- Phakamisa iiseli ezi- A7 ukuya ku-A11 ukuze uzibandakanye njengengxabano yesigaba somsebenzi.
- Thayipha i- comma ukuba uhlule phakathi kobubanzi kunye neengqinamba zeengxabano.
- Emva kohlobo lwe-comma, thayipha ibinzana elithi "<=" & C12 ukulifaka njengengxabano yomqathango.
- Cinezela ukhiye wokungena kwibhodibhodi ukufaka ibakaki yokuvala yokuvala uze ugqibe umsebenzi.
- Impendulo ye-4 ifanele ivele kwiseli B11 kuba zonke ezine iiseli kwiingxabano zoluhlu ziqulethe iinombolo ezingaphantsi okanye ezilinganayo nama-100,000.
- Xa ucofa kwiseli B11 , ifom egcwalisiweyo = ibhunga (A7: A10, "<=" & C12 ibonakala kwifom yefomula ngaphezulu kwephepha lokusebenzela .