Umsebenzi we-Google Spreadsheets 'COUNT ungasetshenziselwa ukubala amaseli womsebenzi oqukethe idatha yocingo.
Lezi zinombolo zingaba:
- izinombolo ezibalwe njengezingxabano kulo msebenzi ngokwayo;
- kumaseli ngaphakathi kwebanga elikhethiwe eliqukethe izinombolo.
Uma inombolo ingeziwe kamuva esitokisini ebangeni elingenalutho noma eliqukethe umbhalo, inani lokubala libuyekeziwe ngokuzenzakalelayo.
Izinombolo ku-Google Spreadsheets
Ngaphezu kwanoma iyiphi inombolo enengqondo - njenge-10, 11.547, -15, noma engu-0 - kunezinye izinhlobo zedatha ezigcinwe njengezinombolo kuma-Google Spreadsheets futhi, ngakho-ke, zizobalwa uma zihlanganisiwe ngezimpendulo zomsebenzi.
Le datha ihlanganisa:
- izinsuku kanye nezikhathi;
- imisebenzi ;
- amafomula ;
- futhi, ngezinye izikhathi, amanani we-Boolean .
I-Function & # 39; s i-Syntax ne-Arguments
I- syntax yomsebenzi ibhekisela kokuhlelwa komsebenzi futhi ihlanganisa igama lomsebenzi, amabakaki, ukwahlukanisa kwama-comma, nokuphikisana.
I-syntax ye-COUNT umsebenzi yile:
= COUNT (value_1, value_2, value_3, ... value_30)
inani_1 - (elidingekayo) izinombolo noma amanani okufanele ahlanganiswe.
value_2, value_3, ... value_30 - (okukhethwa kukho) amanye amanani wedatha noma amareferensi weselula okumele afakwe ohlwini. Inombolo ephezulu yokufakwayo evunyelwe i-30.
Isibonelo somsebenzi esingu-COUNT
Esithombeni esingenhla, ukubhekiselwe kwamaseli kwamaseli ayisishiyagalolunye kufakwe engxabanweni yentengo ye-COUNT umsebenzi.
Izinhlobo eziyisikhombisa ezahlukene zedatha kanye neseli elilodwa elingenalutho lenza ububanzi bokubonisa izinhlobo zedatha ezenzayo futhi ezingasebenzi ne-COUNT umsebenzi.
Izinyathelo ezingezansi imininingwane ingena ku-COUNT umsebenzi nokuphikisana kwayo kwenani eliku-cell A10.
Ukufaka i-COUNT Umsebenzi
I-Google Spreadsheets ayisebenzisi amabhokisi okuxoxa ukuze ufake izingqinamba zomsebenzi njengoba zingatholakala ku-Excel. Esikhundleni salokho, inebhokisi elikhombisa ukuzenzekelayo eliphambuka njengoba igama lomsebenzi lifakwe esitokisini.
- Chofoza ku-cell A10 ukuze wenze iseli elisebenzayo - yilapho imiphumela ye-COUNT umsebenzi izoboniswa;
- Thayipha uphawu olulinganayo (=) olulandelwe igama lokubala komsebenzi ;
- Njengoba uthayipha, ibhokisi eliphakamisa ngokuzenzakalelayo livela ngamagama kanye ne-syntax yemisebenzi eqala ngohlamvu C;
- Uma igama COUNT livela ebhokisini, cindezela ikhi lokungena kwikhibhodi ukuze ufake igama lomsebenzi bese uvula ibakaki nxazonke esitokisini A10;
- Qinisekisa amaseli A1 kuya ku-A9 ukuze uwafake njengengxabano yomsebenzi womsebenzi;
- Cindezela ukhiye wokungena kwikhibhodi ukufaka ibhakha lokuvala " ) " bese uqedela umsebenzi;
- Impendulo 5 kufanele ivele esitokisini A10 kusukela kuphela amahlanu ayisishiyagalolunye amangqamuzana ebangeni aqukethe izinombolo;
- Uma uchofoza ku-cell A10 ifomula egcwalisiwe = COUNT (A1: A9) ibonakala kwibha yefomula ngaphezulu kwephepha lokusebenzela .
Kungani Impendulo Ikhona 5
Amagugu amaseli amahlanu okuqala (A1 kuya ku-A5) ahunyushwa njengedatha yenombolo ngomsebenzi futhi aphendule impendulo ye-5 kuseli A8.
La maseli ayisihlanu okuqala aqukethe:
- inombolo - iseli A1;
- umsebenzi we-SUM - iseli A2;
- ifomu lokufaka - iseli A3;
- usuku - iseli A4;
- isikhathi - iseli A5.
Amaseli amane alandelayo aqukethe idatha engacaciswanga njengedatha yenombolo nge-COUNT umsebenzi futhi, ngakho-ke, inganakiwe ngomsebenzi.
- idatha yombhalo - iseli A6
- ifomula edala inani lephutha # DIV / 0! - iseli A7
- inani le-Boolean FALSE - iseli A8
- iseli elingenalutho - iseli A9
Yini Ethola Ukubala
Njengoba kukhonjisiwe ngenhla, amanani we-Boolean (TRUE noma FALSE) awabalwa ngaso sonke isikhathi njengezinombolo nge-COUNT umsebenzi. Uma inani le-Boolean lifakwe kufinyelelo lezingqinamba zomsebenzi kubalwa njengenombolo.
Uma, njengoba kuboniswe esitokisini se-A8 esithombeni esingenhla, noma kunjalo, ukubhekisela kweseli endaweni yendawo ye-Boolean kufakwe njengenye yezingxabano zexabiso, inani le-Boolean alibalwanga njengenombolo ngomsebenzi.
Ngakho-ke, umsebenzi we-COUNT ubala:
- izinombolo noma amanani we-Boolean angenwe ngokuqondile njengesinye seziphakamiso zomsebenzi
- iselula ngayinye ibhekisela endaweni yedatha yenombolo ekhasini lokusebenzela
- ububanzi bezinkomba zocingo
- ibanga elibizwe
Iyalondoloza amangqamuzana angenalutho namakhombiseli weseli kumaseli aqukethe:
- idatha yombhalo;
- amaphutha wephutha ;
- Amanani we-boolean.