Computer, Software
"COUNTIF" e-Excel: Imizekelo Inkcazelo
I "COUNTIF" - enye sesona upotrebimykh features isicelo spreadsheet enamandla "Excel" ukusuka inkampani "Microsoft". Kutheni kuyimfuneko? Sele kucace umxholo wayo. Kuya kunceda nawuphi na umsebenzisi ukubuza umbuzo "Indlela yokubala iiseli Excel kwindlela ethile?", Ukuze ufumane inombolo efanelekileyo.
umsebenzi iimpikiswano
Lo msebenzi kuthatha iimpikiswano ezimbini ezifunekayo. Eyokuqala kuzo - uluhlu apho ukubala inani leseli ezihlangabezana imeko.
Le ngxoxo yesibini - imeko enokuthi izakucwangciswa kwi ngohlobo amanani okanye amagama, kwakunye ngohlobo iimeko.
Siya alungiselele uluhlu lwe data kwaye sijonge indlela ukukhangela iimpawu ezithile "COUNTIF" kwimizekelo Excel ezisekelwe kuyo. Makhe sithi uluhlu iziqhamo kunye nemifuno kwindawo yokugcina uluhlu lwe ixabiso labo yentengo, izibonelelo ukuthengiswa kunye nomhla lokuthengwa. Iqala ukusebenza kunye neetheyibhuli Excel - ngoku ethatha kwi zekhasi le datha ilandelayo:
A | the | C | D | |
1 | Fruits / nemifino | ixabiso lokuthenga (kg) | Isibonelelo (%) | Umhla lokuthenga |
2 | apples Gold | 74,5 | 28 | 05/01/2017 |
3 | apples Fuji | 69,8 | 50 | 05/16/2017 |
4 | bananas | 41 | 75 | 05/04/2017 |
5 | bananas mini | 74,5 | 42 | 05/14/2017 |
6 | apples Gloster | 54,2 | 34 | 05/15/2017 |
7 | cucumber Chinese | 64 | 17 | 07/05/2017 |
8 | cucumber ezimvumvuzelwa | 110,6 | 28 | 05/16/2017 |
9 | cucumber unsprayed | 132,9 | 28 | 05/01/2017 |
ngengoko ungumongo obalulekileyo
Le ngxoxo yesibini yimeko. Ukuba sifuna ingxabano ukuba ukhankanye inombolo okanye idilesi iseli, ungakwazi alobe ngendlela eyiyo. Ukuba sifuna ukwakha imeko nezintsonkothileyo uthelekiso abalinganiswa, ukukhangela umbhalo, okanye umhla oluthile, lo argument kufuneka livalelwe kuchaphulo olu phindwe. ngezantsi nje iza kuxubusha ngayo usebenzisa "ampersand" uphawu zinokudityaniswa kwimisebenzi ezahlukeneyo.
iimeko Simple ukuba umsebenzi
Kuqaliswa kwicandelo odlulileyo, elinikwe kwiparameters kuya kunceda deal with i "COUNTIF" e-Excel. Le mizekelo ngazo kweli candelo ulula, kodwa ezisisiseko, kwaye cinga ukuba kuyimfuneko, ngaphambi kokuqhubeka lunzima kakhulu.
Xa uhlobo tabular ukunciphisa ifomula, iziphumo ukuphunyezwa kwazo, kwakunye ubhale izimvo emfutshane echazayo. Zonke iimpendulo zisekelwe kwidatha spreadsheet wangena ngasentla, abaleke ngalo mhla 16.05.2017.
umzekelo | impendulo | izimvo |
= COUNTIF (B2: B9; 74.5) | 2 | Lityhila urhwebo indlela ithengwe ngexabiso 74,5 |
= COUNTIF (A2 A9, A2) | 1 | Ukuba le formula "yokunabisa" ekupheleni kwetafile, siza kubona ukuba sibe phindo eziku (ukuba 1 - kuthatha akukho) |
= COUNTIF (D2: D9; NAMHLANJE ()) | 2 | Inani neseli iimpahla, ziya kufumaneka namhlanje (usebenzisa umhla inkqubo yekhompyutha) |
= COUNTIF (C2: C9, "") | 0 | Oku kubala inani leeseli elingabhalwanga kuluhlu. Isilumkiso! Ukuba ufake i indawo iseli, akujongwa njengento engenanto |
= COUNTIF (B2: B9; "<55") | 2 | Inani iiseli ezixabisa ngaphantsi kwe-55 Ngokufanayo, umzekeliso lwenziwa ngaphezu ">" ayilingani "<>" |
= COUNTIF (B2: B9; "<55") + COUNTIF (B2: B9; "> 100") | 4 | Inani lilonke iiseli afumaneka kwi ukuhlanganiswa iimeko ezimbini |
wildcards
I-wildcards ekuthiwa-zisetyenziswa ngokubanzi umsebenzi "COUNTIF" e-Excel. Imizekelo wildcards:
uphawu | incazelo |
* | Text (naliphi na inani loonobumba) |
? | Text (inani loonobumba ehambelana linani lamanqaku question). Isebenza kuphela kwidata yokubhaliweyo! Ukuba iseli akukho ileta enye, uzokuhlala 0 |
umsebenzi ngokupheleleyo ngee tafile e Excel nokucazulula idatha egcinwe kuzo cishe akunakwenzeka ngaphandle kokusebenzisa wildcards.
Iimeko ukuba umsebenzi kunye abasebenzisi be wildcard. yokudibanisa imisebenzi
Kolimo kunye nezinye iimpawu ukudala iimeko adingekayo kwenzeka ngenxa ubhalo iimeko ambaxa ( "ngaphezulu", "ngaphantsi kune", "akalingani") kunye umsebenzi uphawu "ampersand" ezinqwenelekayo (k).
Xa uhlobo tabular, cinga umzekelo ngxuba yokusebenzisa isixhobo "COUNTIF."
umzekelo | impendulo | izimvo |
= COUNTIF (A2: A9, "apile") | 0 | Inani anama kuphela igama elithi "Apples" (Umzekelo ongenavakalelo), nabo bonke |
= COUNTIF (A2: A9; "apile *") | 3 | Inani iiseli eziqala elithi "apile" kunye banye |
= COUNTIF (A2: A9; "* D *") | 3 | Inani iiseli eziqulathe unobumba "d" kuyo nayiphi na inxalenye kwisicatshulwa. Wayedla ukufumana indawo kokunye "okokuqala" ukuba "i" yaye "e" ukuba "e" |
= COUNTIF (A2: A9; "??????") | 1 | Products ne igama ubude 6 kuphela |
= COUNTIF (D2: D9; "<" & (NAMHLANJE () - 10)) | 3 | Inani neseli ngomhla ekuthengwe esingaphezu kweentsuku ezilishumi eyadlulayo |
= COUNTIF (C2: C9; ">" & AVERAGE (C2: C9)) | 3 | Inani neseli ixabiso ngaphezu komndilili athengisa izibonelelo |
Oku kuquka njenge i "COUNTIF" e-Excel.
Imizekelo ekule kweli nqaku liza kukunceda uqonde imigaqo esisiseko zolwakhiwo kunye nendibaniselwano ngeemeko esetyenziswa njenge mpikiswano kusetyenziso lwefowuni, uze ngempumelelo uzisebenzise practice.
Similar articles
Trending Now