I-Excel inemiSebenzi yeeNombolo ezininzi ezingasetyenziselwa ukubala inani leeseli kwindawo ekhethiweyo equle uhlobo oluthile lwedatha.
Umsebenzi we-COUNTA ngumsebenzi wokubala inani leeseli kwibala elingenanto-oko kuthetha ukuba ziqulethe uhlobo oluthile lwedata ezifana neetekisi, iinombolo, iimpazamo zephutha, imihla, amafomula, okanye ixabiso leBoolean .
Umsebenzi uyabalahla iingubo ezingenanto okanye ezingenanto. Ukuba idatha yongezwa kamva kwisitenki esingenalutho umsebenzi ngokuzenzekelayo uhlaziya ngokuzenzekelayo isixa-mali ukuquka ukongeza.
01 ngo 07
Iiseli zokubala eziqukethe umbhalo okanye ezinye iindidi zedatha nge COUNTA
I-Syntax yeCOUNTA kunye neeArguments
I- syntax yomsebenzi ibhekisela kwisakhiwo somsebenzi kwaye ibandakanya igama lomsebenzi, iibakaki, abahluli be-comma kunye neengxabano .
I-syntax yomsebenzi weCOUNTA yile:
= COUNTA (Intengo1, ixabiso2, ... Ixabiso255)
Ixabiso1 - (elifunekayo) iiseli kunye okanye ngaphandle kwedatha okufuneka ifakwe kwibala.
Ixabiso2: Ixabiso255 - (ukhetho) ezongezelelweyo iiseli ukuba zifakwe kwibala. Inani eliphezulu lokungeniswa livunyelwe ngu-255.
Ixabiso leengxabano linokuthi liqule:
- iinkcukacha zeeseli nganye kwiindawo zedatha kwiphepha lokusebenzela
- uluhlu lweenkcukacha zeeseli
- uluhlu olukhethiweyo
02 we-07
Umzekelo: Ukubala iiseli zeDatha ngeCOUNTA
Njengoko kuboniswe kumfanekiso ongentla, iiferensi zeseli kwiiseli ezisixhenxe zifakiwe kwiNgxabano yexabiso le-COUNTA.
Iintlobo ezahlukeneyo zeedatha kunye nesinye sefowuni esingenanto senza uluhlu ukubonisa iintlobo zedatha eza kusebenza kunye neCOUNTA.
Iiseli eziliqela ziqulethe iifomula ezisetyenziselwa ukuvelisa iintlobo ezahlukeneyo zolwazi, njenge:
- i-cell A5 - isebenzisa ifomu ukudala ixabiso lephutha # DIV / 0!
- iseli A7 - isebenzisa ifomula yokuqhathanisa ukudala ixabiso leBoolean TRUE .
03 we-07
Ukungena kwiCOUNTA Umsebenzi
Izinketho zokungena kumsebenzi kunye neengxabano zayo ziquka:
- Ukuthayipha umsebenzi opheleleyo: = COUNTA (A1: A7) kwifayile yeshidi
- Ukukhetha umsebenzi kunye neengxabano zayo usebenzisa ibhokisi yencoko yencoko ye COUNTA
Nangona kunokwenzeka ukuba uthayiphe nje umsebenzi opheleleyo ngesandla, abantu abaninzi bakuthola kulula ukusebenzisa ibhokisi yencoko yababini ukufaka iingxabano zomsebenzi.
Amanyathelo angezantsi angena kumsebenzi usebenzisa ibhokisi yencoko.
04 we-07
Ukuvula Ibhokisi yeDialog
Ukuvula ibhokisi yencoko yencoko ye COUNTA,
- Cofa kwiseli ye-A8 ukwenzela ukuba yenze iseli esebenzayo - yilapho umsebenzi weCOUNTA uza kuba khona
- Cofa kwiThebhu yefomula yerbhoni
- Cofa kwiMisebenzi Engakumbi> Isatisti ukuvula uluhlu lwehla phantsi
- Cofa kwi COUNTA kuloluhlu ukuvula ibhokisi yencoko yencoko yomsebenzi
05 we-07
Ukungena kwiSigqibo sokuSebenza
- Kwibhokisi yencoko, nqakraza kwi- Value1 line
- Phakamisa iiseli ezi-A1 ukuya ku-A7 ukubandakanya loluhlu lwesithenjwa seeseli njengengxabano yomsebenzi
- Cofa u-OK ukugqiba umsebenzi kwaye uvale ibhokisi yencoko
- Impendulo 6 kufuneka ibonakale kwiseli ye-A8 kuba iithandathu ezisixhenxe kwiiseli ezisixhenxe ziluhlu
- Xa ucofa kwi-cell A8 ifom egcwalisiweyo = COUNTA (A1: A7) ibonakala kwifom yefomula ngaphezu kwephepha lokusebenzela
06 we-07
Ukuguqula iziphumo zoMzekelo
- Cofa kwiseli A4
- Thayipha i-comma ( , )
- Cinezela ukhiye wokungena kwikhibhodi
- Impendulo kwiseli ye-A8 kufuneka ishintshele kwi-7 ekubeni iseli ye-A4 ayisenanto
- Cima iziqulatho zeeseli ze-A4 kwaye impendulo kwiseli ye-A8 kufuneka iguqule emva kwe-6
07 we-07
Izizathu zokusebenzisa iNdlela yeBhokisi yeDialog
- Ibhokisi yencoko ibinakekisa i-syntax yomsebenzi - ukwenza kube lula ukufaka iingxabano zomsebenzi omnye ngexesha ngaphandle kokungena kwiibakaki okanye ii-commas ezenza njengabahluli phakathi kweengxabano.
- Izikhokelo zee cell, ezifana ne-A2, A3 kunye ne-A4 zingangeniswa kwifom usebenzisa ukukhomba , oku kuquka ukucofa kwiiseli ezikhethiweyo kunye nemouse kunokuba uzifake kuwo. Akukona nje ukubonisa lula, kunceda ukunciphisa amaphutha kwiimfomula ezibangelwa izikhokelo zeseli ezingalunganga.