Bala zonke iintlobo zeenkcukacha ngeGoogle Spreadsheets COUNTA

Ungasebenzisa umsebenzi we-Google Spreadsheets 'COUNTA ukuba ubale umbhalo, amanani, iimpazamo zephutha, kunye nokunye kwisebe ekhethiweyo yeeseli. Funda indlela ngeemigaqo ezithatha-nge-nyathelo ngezansi.

01 ngo 04

I-COUNTA Umsebenzi

Nangona i-Google Spreadsheets ' Count Count imisebenzi ibala inani leeseli kwindawo ekhethiweyo equlethe uhlobo oluthile lwedatha, umsebenzi weCOUNTA ungasetyenziselwa ukubala inani leeseli kwimiba equlethe zonke iinkcukacha zolwazi ezifana:

• manani;
• imilinganiselo yephutha - njenge-# DIV / 0! kwiseli A3;
• imihla;
• iifomula;
• idatha yombhalo;
• Iimpawu ze-Boolean (TRUE / FALSE).

Umsebenzi uyabalahla iingubo ezingenanto okanye ezingenanto. Ukuba idatha yongezwa kamva kwisitenki esingenalutho umsebenzi ngokuzenzekelayo uhlaziya ngokuzenzekelayo isixa-mali ukuquka ukongeza.

02 we 04

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

xabiso_1 - (efunekayo) iiseli kunye okanye ngaphandle kwedatha okufuneka ifakwe kwibala.

xabiso_2: value_30 - (ukhetho) ezongezelelweyo iiseli ukuba zifakwe kwibala. Inani eliphezulu lokungena elivunyelwe li-30.

Ixabiso leengxabano linokuthi liqule:

• iinkcukacha zeeseli nganye kwiindawo zedatha kwiphepha lokusebenzela
• uluhlu lweenkcukacha zeeseli
• uluhlu olukhethiweyo

Umzekelo: Ukubala iiseli nge COUNTA

Kumzekelo oboniswe kumfanekiso ongentla, uluhlu lweeseli ezivela kwi-A2 ukuya ku-B6 luqulethe idatha efomathiweyo ngeendlela ezahlukeneyo kunye nefowuni enye engenanto ukubonisa iintlobo zedata ezinokubalwa kunye neCOUNTA.

Iiseli eziliqela ziqulethe iifomula ezisetyenziselwa ukuvelisa iintlobo ezahlukeneyo zolwazi, njenge:

• iseli A3 - isebenzisa ifomu (= B2 / B3) ukudala ixabiso lephutha # DIV / 0!
• iseli ye-A4 - isebenzisa ifomula yokuqhathaniswa (= B2> A6) ukuvelisa ixabiso leBoolean TRUE .

03 we 04

Ukungena kwiCOUNTA ngeSiphakamiso se-Auto

I-Google Spreadsheets ayisebenzisi ibhokisi yencoko yababini yokufaka imisebenzi kunye neengxoxo zabo njengoko zifumaneka kwi-Excel.

Endaweni yoko, inebhokisi ephakanyiswa yi- auto ephakamisa njengoko igama lomsebenzi lifakwe kwiseli. Amanyathelo angezantsi angena kwi-COUNTA umsebenzi kwiseli C2 eboniswe kumfanekiso ongentla.

1. Cofa kwiseli C2 ukwenzela ukuba yenze iseli esebenzayo -indawo apho iziphumo zomsebenzi ziza kuboniswa khona;
2. Thayipha uphawu olulinganayo (=) olulandelayo lilandelwe igama lolawulo lomsebenzi ;
3. Njengoko uthayipha, ibhokisi ephakamisa ngokuzenzekelayo ibonakala ngamagama kunye ne-syntax yemisebenzi eqala ngeleta C;
4. Xa igama COUNTA livela phezulu kwibhokisi, cinezela iqhosha lokungena kwikhibhodi ukufaka igama lomsebenzi kunye ne-parenthesis evulekile (ibhola elijikelezayo) kwi-cell C2;
5. Gqamisa iiseli ezi-A2 ukuya kwi-B6 ukuzibandakanya njengeengxoxo zomsebenzi;
6. Cinezela ukhiye wokungena kwibhodibhodi ukongeza abazali bokuvala kunye nokugqiba umsebenzi;
7. Impendulo 9 kufuneka ibonakale kwiseli C2 kuba iiseli ezithoba kuphela ezilishumi ziluhlu luneenkcukacha - i-cell B3 ayinalutho;
8. Ukususa idatha kwezinye iiseli nokuyongeza kwabanye kwi-A2: I-B6 ibangela ukuba iziphumo zomsebenzi zihlaziywe ukuze zibonise utshintsho;
9. Xa ucofa kwiseli C3 ifom egcwalisiweyo = COUNTA (A2: B6) ibonakala kwifom yefomula ngaphezu kwephepha lokusebenzela .

04 we 04

COUNT vs. COUNTA

Ukuze ubonise umehluko phakathi kwemisebenzi emibili, umzekelo kumfanekiso ongentla ukhanyela iziphumo zombini iCOUNTA (iseli C2) kunye nomsebenzi owaziwayo ongu-COUNT (iseli C3).

Ekubeni umsebenzi we-COUNT ubala kuphela iiseli eziqulethe idatha yesazisi, ubuyisela iziphumo ezintlanu ngokuchasene neCOUNTA, ezibala zonke iindidi zedatha kwinqanaba kwaye libuyisela umphumo wezithoba.

Phawula:

• Imihla kunye namaxesha kuthathwa njengamanani kwiGoogle Spreadsheets, yintoni ke idatha kwiiseli zeB4 kunye ne-B5 ibalwa yimisebenzi yomibini;
• Inombolo 27 kwiseli ye-A5 ifakiwe njengombhalo - njengoko kuboniswe ukulungelelaniswa kokungagqibekanga kwedatha kwicala lasekhohlo leseli - kwaye ngenxa yoko, libalwa kuphela yiCOUNTA.