Bala zonke izinhlobo zeDatha nge-Google Spreadsheets COUNTA

Ungasebenzisa umsebenzi we-Google Spreadsheets 'COUNTA ukuze ubale umbhalo, izinombolo, amanani wephutha, nokuningi ebangeni elikhethiwe lamaseli. Funda ukuthi kanjani ngezindlela ezihamba ngezinyathelo ngezansi.

01 ngo-04

I-COUNTA I-Function Overview

Ngenkathi imisebenzi ye-Google Spreadsheets ' Count ibalwa inani lamaseli ebangeni elikhethiwe eliqukethe uhlobo oluthile lwedatha, umsebenzi we-COUNTA ungasetshenziswa ukubala inani lamaseli ebangeni eliqukethe zonke izinhlobo zedatha ezifana:

• izinombolo;
• amaphutha wephutha - njenge- # DIV / 0! esitokisini A3;
• izinsuku;
• amafomula;
• idatha yombhalo;
• Amanani we-boolean (TRUE / FALSE).

Umsebenzi ulahlwa amaseli angenalutho noma angenalutho. Uma idatha ingeziwe ngokuhamba kwesikhathi esitokisini esingenalutho umsebenzi uvuselela ngokuzenzakalelayo isamba sokufaka ukufaka.

02 ka 04

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 (value_1, value_2, ... value_30)

value_1 - (edingekayo) amaseli noma ngaphandle kwedatha okufanele afakwe ohlwini.

inani_2: inani_30 - (okukhethwa kukho) amaseli angeziwe afakwe ohlwini. Inombolo ephezulu yokufakwayo evunyelwe i-30.

Inani lezingxabano lingaqukatha:

• iselula ngayinye ibhekisela endaweni yedatha kushidi lokusebenzela
• ububanzi bezinkomba zocingo
• ibanga elibizwe

Isibonelo: Ukubala Amaseli nge-COUNTA

Esikhathini esiboniswe esithombeni esingenhla, ububanzi bamaseli abuya ku-A2 kuya ku-B6 buqukethe idatha efakwe ngezindlela ezihlukahlukene kanye nesinye isikhala esingenalutho ukubonisa izinhlobo zedatha ezingabalwa nge-COUNTA.

Amaseli amaningana aqukethe amafomula asetshenziselwa ukukhiqiza izinhlobo ezahlukene zedatha, njenge:

• iseli A3 - isebenzisa ifomu (= B2 / B3) ukudala inani lephutha # DIV / 0!
• iseli A4 - isebenzisa ifomula yokuqhathanisa (= B2> A6) ukudala inani le-Boolean TRUE .

03 ka 04

Ukufaka i-COUNTA ngesiphakamiso sokuzenzakalela

I-Google Spreadsheets ayisebenzisi amabhokisi okuxoxa ukuze afake imisebenzi nemibono yabo njengoba ingatholakala ku-Excel.

Esikhundleni salokho, inebhokisi elikhombisa ukuzenzekelayo eliphambuka njengoba igama lomsebenzi lifakwe esitokisini. Izinyathelo ezingezansi kwekhava ezifaka umsebenzi we-COUNTA kuseli C2 eliboniswe esithombeni ngenhla.

1. Chofoza kumakhalekhukhwini C2 ukuze wenze iseli elisebenzayo - indawo lapho imiphumela yomsebenzi izoboniswa khona;
2. Thayipha uphawu olulinganayo (=) olulandelwe igama lebala lomsebenzi;
3. Njengoba uthayipha, ibhokisi eliphakamisa ngokuzenzakalelayo livela ngamagama kanye ne-syntax yemisebenzi eqala nge-C;
4. Uma igama le- COUNTA livela phezulu kwebhokisi, cindezela ukhiye we- Enter ekhibhodi ukuze ufaka igama lomsebenzi kanye ne-parenthesis evulekile (ibhande elijikelezayo) kuseli C2;
5. Gqamisa amaseli A2 kuya ku-B6 ukuze uwafake njengezingqinamba zomsebenzi;
6. Cindezela ukhiye wokungena kwikhibhodi ukwengeza ama-parenthesis wokuvala nokuqedela umsebenzi;
7. Impendulo 9 kufanele ivele esitokisini C2 ngoba amaseli ayisishiyagalolunye kuphela ayishumi ebangeni aqukethe idatha - iseli B3 ayinalutho;
8. Ukususa idatha kwamanye amaseli nokuyengeza kwabanye ebangeni le-A2: B6 kufanele ibangele imiphumela yomsebenzi ukuthi ibuyekezwe ukuze ibonise izinguquko;
9. Uma uchofoza ku-cell C3 ifomula egcwalisiwe = COUNTA (A2: B6) ibonakala kwibha yefomula ngaphezulu kwephepha lokusebenzela .

04 ka 04

COUNT vs. COUNTA

Ukuze ubonise umehluko phakathi kwemisebenzi emibili, isibonelo esithombeni esingenhla siqhathanisa imiphumela ye-COUNTA (iseli C2) nomsebenzi owaziwa kangcono we-COUNT (iselula C3).

Njengoba umsebenzi we-COUNT ubala kuphela amaseli aqukethe idatha yocingo, abuyisela imiphumela emihlanu ngokuphambene neCOUNTA, ebala zonke izinhlobo zedatha ebangeni bese abuyisa umphumela wesishiyagalolunye.

Qaphela:

• Izinsuku nezikhathi zibhekwa njengezinombolo kuma-Google Spreadsheets, yingakho idatha kumaseli B4 no-B5 kubalwa yimisebenzi yombili;
• inombolo engu-27 engqamuzaneni le-A5 ifakiwe njengombhalo - njengoba kuboniswa ukulungiswa okuzenzakalelayo kwedatha ngakwesobunxele beseli - futhi, ngenxa yalokho, kuye kwabalwa kuphela nge-COUNTA.