I-Excel inemisebenzi eminingi yokubala engasetshenziswa ukubala inani lamaseli ebangeni elikhethiwe eliqukethe uhlobo oluthile lwedatha.
Umsebenzi we-COUNTA umsebenzi wokubala ukubala inani lamaseli ebangeni elingenalutho - okusho ukuthi liqukethe uhlobo oluthile lwedatha njengombhalo, izinombolo, amanani wephutha, izinsuku, amafomula, noma amanani we-Boolean .
Umsebenzi ulahlwa amaseli angenalutho noma angenalutho. Uma idatha ingeziwe ngokuhamba kwesikhathi esitokisini esingenalutho umsebenzi uvuselela ngokuzenzakalelayo isamba sokufaka ukufaka.
01 ngo-07
Ama-Count Cell ephethe umbhalo noma ezinye izinhlobo zedatha nge COUNTA
I-Syntax ye-Function ne-Arguments ye-COUNTA
I- syntax yomsebenzi ibhekisela kokuhlelwa komsebenzi futhi ihlanganisa igama lomsebenzi, amabakaki, ukwahlukanisa kwama-comma, nokuphikisana .
I-syntax yomsebenzi we-COUNTA yile:
= COUNTA (Inani1, Inani2, ... Inani255)
I-value1 - (edingekayo) amaseli noma ngaphandle kwedatha okufanele afakwe ohlwini.
I-Value2: Inani255 - (ngokuzithandela) amaseli angeziwe afakwe ohlwini. Inombolo ephezulu yokufakwa okuvunyelwe yi-255.
Inani lezingxabano lingaqukatha:
- iselula ngayinye ibhekisela endaweni yedatha kushidi lokusebenzela
- ububanzi bezinkomba zocingo
- ibanga elibizwe
02 ngo-07
Isibonelo: Ukubala Amaseli WeDatha ngeCOUNTA
Njengoba kuboniswe esithombeni ngenhla, izingcaphuno zeseli kumaseli ayisikhombisa zifakiwe ku-argument ye- Value ye-COUNTA.
Izinhlobo eziyisithupha ezihlukene zedatha kanye nesinye esisodwa esingenalutho senza ububanzi bokubonisa izinhlobo zedatha ezizosebenza ne-COUNTA.
Amaseli amaningana aqukethe amafomula asetshenziselwa ukukhiqiza izinhlobo ezahlukene zedatha, njenge:
- iseli A5 - isebenzisa ifomula ukudala inani lephutha # DIV / 0!
- iseli A7 - isebenzisa ifomula yokuqhathanisa ukuze idale inani le-Boolean TRUE .
03 ka-07
Ukufaka umsebenzi we-COUNTA
Izinketho zokufaka umsebenzi kanye neziphakamiso zalo zifaka:
- Ukuthayipha umsebenzi ophelele: = COUNTA (A1: A7) kufinyelela kuseli lomsebenzi
- Ukukhetha umsebenzi nemibono yayo usebenzisa ibhokisi lebhokisi le-COUNTA
Nakuba kungenzeka nje ukuthayipha umsebenzi ophelele ngesandla, abantu abaningi bakuthola kulula ukusebenzisa ibhokisi lengxoxo ukuze bafake izingxabano zomsebenzi.
Izinyathelo ezingaphansi kwekhava zingena emsebenzini usebenzisa ibhokisi lengxoxo.
04 ka 07
Ukuvula ibhokisi lokuxoxa
Ukuze uvule ibhokisi lengxoxo ye-COUNTA,
- Chofoza kuseli ye-A8 ukuze lenze iseli elisebenzayo - yilapho umsebenzi we-COUNTA uzotholakala khona
- Chofoza kuthebhu yefomathi yebhande
- Chofoza kwimisebenzi eminingi> Isitatimende ukuvula uhlu lokwehliswa komsebenzi
- Chofoza ku-COUNTA kuhlu ukuze uvule ibhokisi lengxoxo lomsebenzi
05 ka-07
Ukufaka Ukungqubuzana Komsebenzi
- Ebhokisini lengxoxo, chofoza ku- Value1 line
- Qinisekisa amaseli A1 kuya ku-A7 ukufaka lolu hlu lwamakholi egciniwe njengengxabano yomsebenzi
- Chofoza OK ukuqedela umsebenzi bese uvala ibhokisi lengxoxo
- Impendulo 6 kufanele ibonakale esitokisini A8 ngoba amaseli ayisithupha kuphela ayisikhombisa ebangeni aqukethe idatha
- Uma uchofoza ku-cell A8 ifomu eligcwalisiwe = COUNTA (A1: A7) ibonakala kwibha yefomula ngaphezulu kwephepha lokusebenzela
06 ka-07
Ukushintsha Imiphumela Yesibonelo
- Chofoza ku-cell A4
- Thayipha ikhoma ( , )
- Cindezela ukhiye wokungena kwikhibhodi
- Impendulo ku-cell A8 kufanele ishintshele ku-7 kusukela iseli A4 engasenalutho
- Susa okuqukethwe kweseli A4 kanye nempendulo kwiseli A8 kufanele ibuyele emuva ku-6
07 ka-07
Izizathu Zokusebenzisa I-Box Dialog Method
- Ibhokisi lebhokisi liyakhathalela i-syntax yomsebenzi - okwenza kube lula ukufaka izingxabano zomsebenzi ngesikhathi esisodwa ngaphandle kokufaka amabakaki noma ama-commas asebenza njengabahlukanisi phakathi kwezimpikiswano.
- Izinkomba zeselula, njenge-A2, A3, ne-A4 zingangena kwifomula ngokukhomba , okubandakanya ukuchofoza amaseli akhethiwe negundane kunokuba uzifake. Akukhona nje ukukhomba okulula, futhi kusiza ukunciphisa amaphutha kumafomula abangelwa izikhombisi zeseli ezingalungile.