Amakhompyutha, Isofthiwe
"COUNTIF" Excel: Izibonelo Incazelo
I "COUNTIF" - omunye njalo kunazo upotrebimykh izici isipredishithi isicelo enamandla "Excel" kusukela inkampani "Microsoft". Kuqakatheke ngani? Kuyinto kakade kucace kusukela kusihloko salo. Kuyokusiza yimuphi umsebenzisi ukubuza umbuzo "kanjani ukubala amaseli Excel ngemibandela ethize?", Ukuze uthole inombolo efanele.
kwemisebenzi
Lokhu umsebenzi esithatha izimpikiswano ezimbili edingekayo. Eyokuqala wabo - ibanga lapho ukubala inani lamaseli ezihlangabezana isimo.
Eyesibili agumenti - isimo ukuthi kungenziwa isethwe ngesimo izinombolo noma amagama, kanye ngesimo izimo.
Sizokwenza ukulungiselela uhla idatha futhi sibheke indlela ukubheka izici ezithile "COUNTIF" Excel izibonelo kwezindlu kusekelwe kuyo. Ake sithi sinalo uhlu izithelo nemifino yokubeka nge uhlu intengo zabo zokuthenga, yokuthengisa izibonelelo usuku lokuthenga. Ucala umsebenzi nge amatafula ku-Excel - manje ukuthatha lokusebenzela idatha elandelayo:
A | I | C | D | |
1 | Izithelo / Imifino | yentengo (kg) | Allowance (%) | Usuku lokuthenga |
2 | apula Gold | 74,5 | 28 | 05/01/2017 |
3 | apula Fuji | 69,8 | 50 | 05/16/2017 |
4 | ubhanana | 41 | 75 | 05/04/2017 |
5 | ubhanana mini | 74,5 | 42 | 05/14/2017 |
6 | apula Gloster | 54,2 | 34 | 05/15/2017 |
7 | ikhukhamba Chinese | 64 | 17 | 07/05/2017 |
8 | ikhukhamba impova | 110,6 | 28 | 05/16/2017 |
9 | ikhukhamba unsprayed | 132,9 | 28 | 05/01/2017 |
i umphelelisi ebalulekile
I-agumenti yesibili yisimo. Uma sifuna nengxabano ucacise inombolo noma ikheli yeseli, ungarekhoda endleleni efanele. Uma sifuna ukwakha isimo eziyinkimbinkimbi nge Ukuqhathanisa izinhlamvu, ukucinga umbhalo, noma ngosuku oluthile, i-agumenti kumele ebiyelwe izingcaphuno. ngezansi nje ngeke sixoxe nangendlela usebenzisa "ampersand" uphawu zingahlanganiswa imisebenzi ehlukahlukene enikeziwe.
izimo Simple for umsebenzi
Ibe esigabeni langaphambilini, isethi idatha kuzokusiza wazisingatha "COUNTIF" Excel. Izibonelo okuxoxwe ngazo kulesi sigaba ulula, kodwa kuyisidingo, futhi ababheke kudingekile, ngaphambi kokuqhubeka eziyinkimbinkimbi ngokwengeziwe.
In ifomu tabular thina banciphise ifomula, imiphumela ukuqaliswa zabo, kanye nokubhala uphawula kafushane kube kanye achazayo. Zonke izimpendulo zisekelwe idatha-spreadsheet oyifakile, futhi ukusebenzisa ngosuku 16.05.2017.
Ngokwesibonelo | impendulo | amazwana |
= COUNTIF (B2: B9; 74.5) | 2 | Lembula okuthengiswayo kangakanani uthenge ngentengo 74,5 |
= COUNTIF (A2 A9, A2) | 1 | Uma lokhu ifomula "elula" kuze kube sekupheleni kwetafula, sizobe sibone ukuthi sinaso Izinto impinda (uma 1 - kuthatha akukho) |
= COUNTIF (D2: D9; NAMUHLA ()) | 2 | Inombolo amaseli nge izimpahla, izotholakala namuhla (usebenzisa usuku uhlelo sekhompyutha) |
= COUNTIF (C2: C9, "") | 0 | It ubala inani lamaseli angenalutho kububanzi. Isexwayiso! Uma ufake isikhala esitokisini, it is hhayi kubhekwe njengento ezingenalutho |
= COUNTIF (B2: B9; "<55") | 2 | Inombolo amaseli nge value of esingaphansi 55. Ngokufanayo, lesi sifaniso wenziwa ezingaphezu kuka ">" akalingani "<>" |
= COUNTIF (B2: B9; "<55") + COUNTIF (B2: B9; "> 100") | 4 | Inani lamaseli ezitholakele ku-inhlanganisela izimo ezimbili |
wildcards
Okubizwa ngokuthi wildcards kabanzi nge umsebenzi "COUNTIF" Excel. Izibonelo wildcards:
uphawu | incazelo |
* | Umbhalo (iyiphi Inani lezinhlamvu) |
? | Umbhalo (Inani lezinhlamvu elihambisana inani bomabuta). Isebenza kuphela nge idatha umbhalo! Uma iseli akuyona incwadi eyodwa, sizohlala 0 |
umsebenzi Okugcwele nethebula Excel futhi sihlaziye idatha egcinwe kuzo cishe akunakwenzeka ngaphandle kokusebenzisa wildcards.
NeMibandela umsebenzi nge isikhethi izinhlamvu. ngokuhlanganisa imisebenzi
Inhlanganisela nezinye izici ukudala izimo ofiselekayo kwenzeka ngenxa okunengqondo izimo kwakwakhe ( "ngaphezulu", "mbalwa kuna", "akulingani") kanye oyifunayo umsebenzi uphawu "ampersand" (k).
In ifomu tabular, cabangela isibonelo ngaphezulu eyinkimbinkimbi usebenzisa ithuluzi "COUNTIF."
Ngokwesibonelo | impendulo | amazwana |
= COUNTIF (A2: A9, "apula") | 0 | Inombolo anama kuphela igama elithi "Ama-apula" (uma izinhliziyo ezilukhuni), futhi bonke |
= COUNTIF (A2: A9; "apula *") | 3 | Isibalo amaseli uqale ngegama elithi "apula" futhi banye |
= COUNTIF (A2: A9; "* D *") | 3 | Isibalo amaseli eziqukethe uhlamvu "d" nganoma iyiphi ingxenye yombhalo. Ngokuvamile esetshenziswa ukuthola futhi esikhundleni ukuze uthole okunye "kuqala" ukuze "i" futhi "e" ukuze "e" |
= COUNTIF (A2: A9; "??????") | 1 | Imikhiqizo igama ubude nezinhlamvu 6 kuphela |
= COUNTIF (D2: D9; "<" & (NAMUHLA () - 10)) | 3 | Inombolo amaseli nge usuku ukuthengwa izinsuku ezingaphezu kweshumi edlule |
= COUNTIF (C2: C9; ">" & ISILINGANISO (C2: C9)) | 3 | Inombolo amaseli nge kunani isilinganiso ethengisa izibonelelo |
Lokhu uyaphetha njenge "COUNTIF" Excel.
Izibonelo okukulesi sihloko kuzokusiza uqonde izindlela eziyisisekelo zokusebenzisa ukwakhiwa kanye inhlanganisela yezimo ezisetshenziswa njengeziwusizo agumenti umsebenzi, futhi ngempumelelo uzisebenzise umkhuba.
Similar articles
Trending Now